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 |
+---------------------+
