Home » RDBMS Server » Server Administration » Date comparing in decode statement
Date comparing in decode statement [message #370432] Fri, 24 September 1999 08:57 Go to next message
Armin
Messages: 2
Registered: September 1999
Junior Member
Comparing 'equal to' within the decode statement is
no problem, but how can I perform 'Greater than' or
'Less than' with date values
Re: Date comparing in decode statement [message #370442 is a reply to message #370432] Fri, 24 September 1999 13:35 Go to previous message
MikeG
Messages: 14
Registered: August 1999
Junior Member
By subtracting the dates and then doing a sgn to return either -1, 0, or 1 you can determine if 1 is greater, equal to, or less than the other.
Previous Topic: Sending email from forms 5.0 to Lotus notes
Next Topic: Help on ER Modelling
Goto Forum:
  


Current Time: Thu Mar 28 08:07:42 CDT 2024