TIMESTAMPDIFF
Find between two date or datetime objects the time difference in the specified unit.
Syntax
TIMESTAMPDIFF ({YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MICROSECOND}, date1, date2)
Arguments
date1, date2: a valid date, datetime, or parsable date string
Return Type
Integer. If date1 or date2 is not a valid date, returns NULL.
Examples
SELECT TIMESTAMPDIFF(QUARTER, '2009-02-13', '2013-09-01'); **** +----------------------------------------------------+ | TIMESTAMPDIFF(QUARTER, '2009-02-13', '2013-09-01') | +----------------------------------------------------+ | 18 | +----------------------------------------------------+
SELECT TIMESTAMPDIFF(SECOND, '2009-02-14 01:17:01', '2009-02-13 23:31:30'); **** +---------------------------------------------------------------------+ | TIMESTAMPDIFF(SECOND, '2009-02-14 01:17:01', '2009-02-13 23:31:30') | +---------------------------------------------------------------------+ | -6331 | +---------------------------------------------------------------------+
Related Topics