Mysql - Syntax to find difference between two dates, How to find diff between two given dates
Syntax to find difference between two dates
To find the different between two given dates in months:period_diff is a mysql function which is used to find the difference between two given dates. This will help to find the difference between any given dates.
Use PeriodDiff mysql function
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_period-diff
Example:
select period_diff(date_format(date1row, '%Y%m'), date_format(date2row, '%Y%m')) as months from your_table;
The topic on Mysql - Syntax to find difference between two dates is posted by - Math
Hope you have enjoyed, Mysql - Syntax to find difference between two datesThanks for your time