Re: Comparing against time aswell as date

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 28 Jul 1998 15:35:15 GMT
Message-ID: <35bdef8e.5642333@192.86.155.100>

A copy of this was sent to Declan O'Reilly <declan_at_mcs.com> (if that email address didn't require changing) On Tue, 28 Jul 1998 10:07:17 -0500, you wrote:

>Hi
> How do I compare the time aswell as the date ie. the following
>'28-Jul-98 08:00:00' does not seem to work.
>
> select to_char(applydate,'DD-MON-YY HH24:MI:SS'),
> to_char(startdatetime,'DD-MON-YY HH24:MI:SS') from total
> where startdatetime > '28-Jul-98 08:00:00'
> order by startdatetime desc
>
>
>Thanks
>Declan O'Reilly

try

where startdatetime > to_date( '28-Jul-98 08:00:00', 'DD-MON-YY HH24:MI:SS')

that'll do it.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jul 28 1998 - 10:35:15 CDT