Outdated Version

You are viewing an older version of this section. View current production version.


Subtracts to find the number of days between two dates.

DATEDIFF(date1, date2)


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


memsql> select datediff('2016-05-31', now()) as days_til_graduation;
| days_til_graduation |
|                 455 |