You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

DATEDIFF

Subtracts to find the number of days between two dates.

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

mysql> 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.

mysql> 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.

mysql> select datediff('2099-12-31', now()) as days_til_graduation;
+---------------------+
| days_til_graduation |
+---------------------+
|               30229 |
+---------------------+