Re: time-date-comparison

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 12 Oct 1998 13:27:04 GMT
Message-ID: <3622036a.3969277@192.86.155.100>

A copy of this was sent to "Corinna Becker" <Corinna.Becker_at_removethis.memo.ikea.com> (if that email address didn't require changing) On 12 Oct 1998 09:23:14 GMT, you wrote:

>Hello,
>how can I make a comparison between to dates with the time? I want to
>select all columns that are older than 10.10.98 and older than 19:00
>o'clock.
>Thanks in advance
>Corinna Becker

select *
  from T
 where date_column > to_date( '10.10.1998 19:00', 'dd.mm.yyyy hh24:mi' );

will 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 Mon Oct 12 1998 - 08:27:04 CDT