Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

The unit for the result is given by the unit argument. The unit should be one of the following values: FRAC_SECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR. mysql> mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01'); +------------------------------------------------+ | TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') | +------------------------------------------------+ |                                              3 | +------------------------------------------------+ 1 row in set (0.00 sec)