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
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
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: Wed Apr 14 17:39:25 CDT 2021