Product Solutions Support
Try MemSQL

TIMEDIFF

Subtracts to find the amount of time between two datetimes or times.

TIMEDIFF(date1, date2)

Arguments

Return Type

Time object. If date1 or date2 is not a valid time/datetime or the types don’t match, returns NULL.

Info

The TIME object can only express intervals between -838:59:59 and 838:59:59.

Examples

memsql> select timediff('2015-02-13 23:31:30', now()) as time_since_graduation;
+-----------------------+
| time_since_graduation |
+-----------------------+
| -433:58:39            |
+-----------------------+
Was this article useful?