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 the given interval of time to a date or datetime object.


DATE_SUB (dateobj, INTERVAL expr unit)
SUBDATE (dateobj, INTERVAL expr unit)
SUBDATE (dateobj, days)


  • dateobj: a valid date, datetime, or parsable date string
  • expr: the number of units to add if unit is a simple type, or a string representation of the units to add if unit is a complex type. Can be negative.
  • days: number of days to subtract. Can be negative.

See DATE_ADD for a description of unit.

Return Type

Date or datetime object. If dateobj is not a valid date, returns NULL.


memsql> select DATE_SUB('2010-04-02', INTERVAL 1 WEEK);
| DATE_SUB("2010-04-02", INTERVAL 1 WEEK) |
| 2010-03-26                              |