Loading lesson path
Concept visual
Start at both ends
Return the number of days between two date values:
SELECT DATEDIFF("2017-06-25", "2017-06-15");The DATEDIFF() function returns the number of days between two date values.
date1, date2 )
Description date1, date2 Required. Two dates to calculate the number of days between. (date1 - date2)
From MySQL 4.0
Return the number of days between two date values: SELECT DATEDIFF("2017-06-25 09:34:21", "2017-06-15 15:25:35");
Return the number of days between two date values:
SELECT DATEDIFF("2017-01-01",
"2016-12-24");❮ MySQL Functions