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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Sending email from forms 5.0 to Lotus notes
Next Topic: Help on ER Modelling
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 27 15:42:13 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.