ADSM-L

Re: changeing bytes to gigabytes

2002-05-23 20:40:52
Subject: Re: changeing bytes to gigabytes
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Thu, 23 May 2002 20:38:15 -0400
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


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