DATE_COMPARE

The date function is used to compare one date or time value to another. It returns an integer value of 1 if the first value is after the second value, -1 if the first value is before the second value, and 0 if the two values are equal.

Parameter	Type
`startDate`	datetimestamp, datetime, date, time, gyear, gyearmonth
`endDate`	datetimestamp, datetime, date, time, gyear, gyearmonth

Returns: integer

Example

query:

SELECT DATE_COMPARE(CAST("2018-01-02" AS DATE), CAST("2018-01-03" AS DATE))

siyeh/sql-crm-example-data Run query Copy code

results:

date_compare
-1