Product Solutions Support
Try MemSQL

TIMESTAMPDIFF

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)

Arguments

Return Type

Integer. If date1 or date2 is not a valid date, returns NULL.

Examples

memsql> select timestampdiff(QUARTER, '2009-02-13', '2013-09-01');
+----------------------------------------------------+
| timestampdiff(QUARTER, '2009-02-13', '2013-09-01') |
+----------------------------------------------------+
|                                                 18 |
+----------------------------------------------------+

memsql> 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 |
+---------------------------------------------------------------------+
Was this article useful?