![]() Previous |
![]() Next |
You can compare two dates with any of the Boolean comparison operators. For dates, "less" means before and "greater" means after. The expressions being compared can include any of the date calculations discussed in Table: Comparison and Logical Operators. For example, in a billing application, you can determine whether today is 60 or more days after the billing date to send out a more strongly worded bill.
bill.date + 60 LE SYSDATE
Dates also have a numeric value. You can use the TO_NUMBER and TO_DATE functions to change a value from a DATE
to an INTEGER
or an INTEGER
to a DATE
for comparison.