Re: select command

Hi Mr Chandrasekhar,

You could probably use something like :

Select blah ... where cast((scheduled_start-current_timestamp)hours as
decimal) < 24
In this case you can replace hours by minutes or even seconds 
or select blah ... where dayname(scheduled_start) ='Tuesday'

Hope it helped !

Arnaud                         
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group     |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01       | 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



-----Original Message-----
From: Chandrasekhar, C.R [mailto:CHARAKOC AT TIMKEN DOT COM] 
Sent: Tuesday, 11 February, 2003 6:03
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select command


hi TSM guys,

How can I write equivalent select command for the following command.

q event * *  begindate=today-1 enddate=today-1

I tried many ways to achieve  this some were Iam facing problem while
manipulating date function.

Thanks,

chandrasekhar.cr
System Executive,
Tivoli Certified Consultant.




**********************************************************************
This message and any attachments are intended for the individual or
entity named above. If you are not the intended recipient, please do not
forward, copy, print, use or disclose this communication to others; also
please notify the sender by replying to this message, and then delete it
from your system.

The Timken Company
**********************************************************************