Re: Date Comparison in Oracle

[Jeff Hill <jhill@AGCONSULT.COM>]

In order for this date logic to work properly, you need to first convert
the date into YYYYMMDD format.





"Hope, Sandra" <HopeS@DYNCORP.COM> on 09/24/98 07:57:32 AM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Jeffrey Hill/Application Group)
Subject:  Date Comparison in Oracle




I need to select the earlier of several dates within an SQR.
I've tried various date formats and using

  if $Date1 < Date2
        let $Date3 = Date2
  end-if

I don't get date errors but the program simply replaces each date whether
it
is earlier or not.  Is there a special format required for this syntax or
is
there a different way to compare dates?   Thanks All.

SHope