Mysql Diff Date In Days. Date2 a date datetime value. Select datediff 2017 06 25 09 34 21 2017 06 15 15 25 35.
Date2 a date datetime value. The accepted answer is almost correct but can lead to wrong results. Return the number of days between two date values.
As shown clearly in the result because 2016 is the leap year the difference in days between two dates is 2 365 366 1096.
Select datediff 2017 06 25 09 34 21 2017 06 15 15 25 35. Notice that the datediff function takes the leap year into account. The mysql datediff function s default return value is the number of days between two date or datetime expressions. The mysql datediff function calculates the number of days between two date datetime or timestamp values.
