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
On Fri, 2004-06-11 at 10:01, David E Ehresman wrote: > 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 > start_time>current_times > tamp-1 day and activity='MIGRATION' group by entity > > except instead of going back 1 day I would like to check since > yesterday at 18:00. > > David -- Mahesh Tailor WAN/TSM/NetView Administrator Carilion Health System Information Services 37 Reserve Avenue Roanoke, VA 24016 Phone: 540.224.3929 Fax: 540.224.3954
