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

Last modified: May 31, 2023

Was this article helpful?