SQL Time Construct
2004-06-11 10:01:50
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>
|
- SQL Time Construct,
David E Ehresman <=
|
|
|