You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.


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


TIMEDIFF(date1, date2)


  • date1, date2: a valid time, datetime, or parsable time/datetime string. Both arguments should be of the same type.

Return Type

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


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


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