Re: time-date-comparison

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Mon, 12 Oct 1998 15:00:28 +0100
Message-ID: <6vt20o$t71$1@schbbs.mot.com>

Unless I misunderstand the question. If you have two date columns you wish to compare then just compare them, i.e.

AND MyDateCol1 < MyDateCol2

If you have a string literal containing date and time then

AND MyDateCOl1 < TO_DATE(MyString, 'DD_MON-YYYY HH24:MI:SS')

i.e. just remember to include the time format when converting.

--
Alan D. Mills

Corinna Becker wrote in message
<01bdf5ca$4529ad00$a049100a_at_pc743-sode.seurope.ikea.com>...
>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
Received on Mon Oct 12 1998 - 09:00:28 CDT