From: "Bo Gundersen" <bo@timechain.com>
Subject: Re: date comparison
Date: 2000/08/04
Message-ID: <1Gyi5.14553$MJ5.199663@twister.sunsite.auc.dk>#1/1
References: <0d24a28c.1e0e6ff3@usw-ex0109-068.remarq.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Trace: twister.sunsite.auc.dk 965392125 130.225.199.6 (Fri, 04 Aug 2000 14:28:45 MET DST)
Organization: Timechain Technology ApS
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 04 Aug 2000 14:28:45 MET DST
Newsgroups: comp.databases.oracle.tools


"Sandy" <daleelaNOdaSPAM@usa.net.invalid> wrote in message
news:0d24a28c.1e0e6ff3@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.com