Mysql Diff Date. Datediff 2008 05 17 11 31 31 2008 04 28 19 1 row. The way it works is you provide two arguments one for each date and datediff will return the number of days between the two dates.
Select datediff 2017 06 25 09 34 21 2017 06 15 15 25 35. Mysql select datediff 2008 05 17 11 31 31 2008 04 28. The mysql datediff function calculates the number of days between two date datetime or timestamp values.
Let s take some mysql datediff examples.
In mysql you can use the datediff function to find the difference between two dates. Date2 a date datetime value. The datediff function accepts two arguments that can be any valid date or date time values. The way it works is you provide two arguments one for each date and datediff will return the number of days between the two dates.