Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
DATE_CMP function
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
DATE
or an expression that evaluates to aDATE
type. - date2
-
A column of data type
DATE
or an expression that evaluates to aDATE
type.
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)