The time difference function for MySql to calculate two dates

MySql calculates the time difference between two dates function TIMESTAMPDIFF usage: Syntax: Java code TIMESTAMPDIFF (interval, datetime_expr1, datetime_expr2) www.2cto.com description: 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. Select timestampdiff (MONTH, '2017-10-01 ', '2017-09-01'); interval however: second seconds minute minutes hour time HOURS DAY DAYS MONTH MONTHS YEAR YEARS