Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Find between two date or datetime objects the time difference in the specified unit.
TIMESTAMPDIFF ({YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MICROSECOND}, date1, date2)
Integer. If date1 or date2 is not a valid date, returns NULL.
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