----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: s_hashim Message 3 in Discussion Thank You Very much Mohan I got the solution -----Original Message----- From: DecidedMTR [mailto:[EMAIL PROTECTED] Sent: Monday, December 29, 2003 5:20 PM To: [EMAIL PROTECTED] Subject: Re: Oracle SQL Query New Message on BDOTNET Oracle SQL Query Reply Reply to Sender Recommend Message 2 in Discussion From: DecidedMTR <o:p> </o:p> Pls change <st1:City><st1:place>ur</st1:place></st1:City> query to<o:p></o:p> <o:p></o:p> SELECT * from TableName where UPDATE_DATE >= to_date('12/17/2003 <st1:time Hour="0" Minute="0">00:00:01</st1:time>', 'MM/DD/YYYY hh24:mi:ss') AND UPDATE_DATE <= to_date('12/18/2003 <st1:time Hour="23" Minute="59">23:59:59</st1:time>', 'MM/DD/YYYY hh24:mi:ss');<o:p></o:p> <o:p> </o:p> Thanks & regards<o:p></o:p> Mohan<o:p></o:p> <o:p> </o:p> View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
