Re: changeing bytes to gigabytes
2002-05-23 20:40:52
You may not be aware but there are at least 3 valid date formats:
YYYY-MM-DD
YYYY-MM-DD HH:MM:SS
YYYY-MM-DD HH:MM:SS.xxxxxx
In the where clause add:
and start_time >= timestamp('2002-05-22')
Start_time is a timestamp (26 characters in text, but internal binary thing
when stored). What happens in the above is it gets expanded to 2002-05-22
00:00:00.000000
You can also do this:
and date(start_time) >= date('2002-05-22')
The key is the comparison must be like formats in TSM.
Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180
|
|
|