Mysql Diff Date In Days. Date1 a date datetime value. If both dates are after 1970 you can substract timestamps.
In order to be more accurate you have to divide it by the average days in years for 4 years aka 365 4 1 the leap year every 4 years 365 25. The following statement will return the days between two datetime expressions 2008 05 17 11 31 31 and 2008 04 28. The syntax of the mysql datediff function is as follows.
Date2 a date datetime value.
The mysql datediff syntax is. The following statement will return the days between two datetime expressions 2008 05 17 11 31 31 and 2008 04 28. Let s take some mysql datediff examples. Date1 date2 technical details.
