Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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

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.

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.

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