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:[EMAIL PROTECTED]] Sent: Tuesday, 11 February, 2003 6:03 To: [EMAIL PROTECTED] 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 **********************************************************************
