Example Return the number of days between two date values: SELECT DATEDIFF("2017-06-25 09:34:21", "2017-06-15 15:25:35"); Try it Yourself » Example Return the number of days between two date values: SELECT DATEDIFF("2017-01-01", "2016-12-24"); Try it Yourself » ...
DATEDIFF DATE_ADD DATE_FORMAT DATE_SUB DAY DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS HOUR LAST_DAY LOCALTIME LOCALTIMESTAMP MAKEDATE MAKETIME MICROSECOND MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT...