#### 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