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.
Subtracts to find the number of days between two dates.
DATEDIFF(date1, date2)
Integer. If date1 or date2 is not a valid date, returns NULL.
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 |
+---------------------+