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
-----Original Message-----
From: Chuck Lam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 7:16 PM
To: [EMAIL PROTECTED]
Subject: Re: changeing bytes to gigabytes
Hey, Paul, I liked this select statement.
One question, if I want the summary to include only
activities in 2002-05-22, how do I do that?
As you know, the start_time has this format yyyy-mm-dd hh:mm:ss.000000.
What should I put in my select statement to leave out the hh:mm:ss.000000
part?
Thanks.
TIA
--- "Seay, Paul" <[EMAIL PROTECTED]> wrote:
> Select entity, cast(bytes/1024/1024/1024 as
> decimal(8,2)) as "Gigabytes "
> from summary
>
> Paul D. Seay, Jr.
> Technical Specialist
> Naptheon, INC
> 757-688-8180
>
>
> -----Original Message-----
> From: Blair, Georgia [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 11:52 AM
> To: [EMAIL PROTECTED]
> Subject: changeing bytes to gigabytes
>
>
> I am using the summary table to monitor how much
> data migrates from disk on
> a daily basis. What is the easiest way to find
> change the amount to
> gigabytes versus bytes? Or does someone have a
> particular select statement
> for this.
>
> Thanks in advance
> [EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
