ADSM-L

SQL Time Construct

2004-06-11 10:01:50
Subject: SQL Time Construct
From: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 11 Jun 2004 10:01:25 -0400
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

<Prev in Thread] Current Thread [Next in Thread>