Re: Date Comparison in Oracle

["Singh, Rajvirendra ( NYSDS )" <RajvirendraSingh@EXCHANGE.ML.COM>]

I think your $date1 and $date2 format should be in YYYYMMDD format.

Raj
        -----Original Message-----
        From:   Hope, Sandra [SMTP:HopeS@DYNCORP.COM]
        Sent:   Thursday, September 24, 1998 10:58 AM
        To:     Multiple recipients of list SQR-USERS
        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