Mysql calculates time difference function _mysql

MySQL calculates a two-date time difference function Timestampdiff usage:
Grammar:
Timestampdiff (INTERVAL,DATETIME_EXPR1,DATETIME_EXPR2)
Description
Returns the integer difference between a date or datetime expression Datetime_expr1 and datetime_expr2the. of its results
The unit is given by the interval parameter. The legal value of the interval is the same as those listed in the Timestampadd () function description.

Copy Code code as follows:

SELECT Timestampdiff (MONTH, ' 2009-10-01 ', ' 2009-09-01 ');
Interval but:
SECOND seconds SECONDS
MINUTE minutes MINUTES
HOUR Time HOURS
Day days
MONTH Month MONTHS
Year YEARS