Mysql time difference calculation function

Use TIMESTAMPDIFF to calculate the time difference between two dates in MySql:
Syntax:
TIMESTAMPDIFF (interval, datetime_expr1, datetime_expr2)
Note:
Returns the integer difference between datetime_expr1 and datetime_expr2the. The result
The unit is given by the interval parameter. The legal value of interval is the same as that listed in the TIMESTAMPADD () function description.
Copy codeThe Code is as follows:
Select timestampdiff (MONTH, '2017-10-01 ', '2017-09-01 ');
Interval:
SECOND SECONDS
MINUTE MINUTES
HOUR time HOURS
DAY DAYS
MONTH-MONTH MONTHS
YEAR YEARS