Would this work?
select entity,\
cast((cast(sum(bytes) as decimal(20,3))/1024/1024)+.05 as \
decimal(10,1)) as "Migrated (MB)" from summary where \
time(start_time)>='18:00:00' and \
cast((current_timestamp-start_time)hours as decimal(8,0))<24 \
and activity='MIGRATION' group by entity
Is there a tms sql time contruct that will allow me to query all the
entries with a start time greater than yesterday at 18:00?
Specifically the query is:
tsm: ULTSM>select entity,cast((cast(sum(bytes) as
decimal(20,3))/1024/1024)+.05
as decimal(10,1)) as "Migrated (MB)" from summary where
star
