DATE_CMP compares two dates. The function returns 0 if the dates are
identical, 1 if date1 is greater, and -1 if
date2 is greater.
Syntax
DATE_CMP(date1, date2)
Arguments
- date1
-
A column of data type
DATEor an expression that evaluates to aDATEtype. - date2
-
A column of data type
DATEor an expression that evaluates to aDATEtype.
Return type
INTEGER
Examples
The following query compares the DATE values in the CALDATE column to the date January 4, 2008 and
returns whether the value in CALDATE is before (-1), equal to
(0), or after (1) January 4, 2008:
select caldate, '2008-01-04',
date_cmp(caldate,'2008-01-04')
from date
order by dateid
limit 10;
caldate | ?column? | date_cmp
-----------+------------+----------
2008-01-01 | 2008-01-04 | -1
2008-01-02 | 2008-01-04 | -1
2008-01-03 | 2008-01-04 | -1
2008-01-04 | 2008-01-04 | 0
2008-01-05 | 2008-01-04 | 1
2008-01-06 | 2008-01-04 | 1
2008-01-07 | 2008-01-04 | 1
2008-01-08 | 2008-01-04 | 1
2008-01-09 | 2008-01-04 | 1
2008-01-10 | 2008-01-04 | 1
(10 rows)