Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Time\s+Construct\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Time\s+Construct\s*$/: 2 ]

Total 2 documents matching your query.

1. SQL Time Construct (score: 1): Author: David E Ehresman <deehre01 AT LOUISVILLE 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(byte; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-06/msg00382.html (10,527 bytes)
2. Re: SQL Time Construct (score: 1): Author: Mahesh Tailor <mahesh.tailor AT NETWORK.CARILION DOT COM>; Date: Fri, 11 Jun 2004 10:09:46 -0400; 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_ti; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-06/msg00384.html (11,415 bytes)

Current List: 1 - 2
Page: [1]