[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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