Re: date comparison
From: Bo Gundersen <bo_at_timechain.com>
Date: 2000/08/04
Message-ID: <1Gyi5.14553$MJ5.199663_at_twister.sunsite.auc.dk>#1/1
Date: 2000/08/04
Message-ID: <1Gyi5.14553$MJ5.199663_at_twister.sunsite.auc.dk>#1/1
"Sandy" <daleelaNOdaSPAM_at_usa.net.invalid> wrote in message
news:0d24a28c.1e0e6ff3_at_usw-ex0109-068.remarq.com...
> hi,
>
> I would like to know if there is a function which compares
> dates.
> for example to see if 03/06/2000 > 08/09/2000
The easiest way would be to just convert the strings to dates using TO_DATE,
and compare the two dates.
Example:
TO_DATE('03/06/2000') > TO_DATE('08/09/2000')
Be sure that the strings given comply with your NLS settings for dates.
Hope this helps :)
-- Bo Gundersen R&D Timechain Technology http://www.timechain.comReceived on Fri Aug 04 2000 - 00:00:00 CEST