Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

DATEDIFF

Syntax

DATEDIFF(date1, date2)

Arguments

date1, date2: a valid date, datetime, or parsable date string. Only the date part is used.

Return Type

Integer. If date1 or date2 is not a valid date, returns NULL.

Examples

SQL

SELECT DATEDIFF('2017-03-27', '2017-03-26') AS days_til_graduation;

+---------------------+
| days_til_graduation |
+---------------------+
|                   1 |
+---------------------+

If date1 is in the past, the function returns a negative result.

SQL

SELECT DATEDIFF('2017-03-26', '2017-03-27') AS days_til_graduation;

+---------------------+
| days_til_graduation |
+---------------------+
|                  -1 |
+---------------------+

NOW() can be used as one of the parameters.

SQL

SELECT DATEDIFF('2099-12-31', NOW()) AS days_til_graduation;

+---------------------+
| days_til_graduation |
+---------------------+
|               30229 |
+---------------------+