Product Solutions Support
Try MemSQL

DATE_SUB

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)

Arguments

See DATE_ADD for a description of unit.

Return Type

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

Examples

memsql> select DATE_SUB("2010-04-02", INTERVAL 1 WEEK);
+-----------------------------------------+
| DATE_SUB("2010-04-02", INTERVAL 1 WEEK) |
+-----------------------------------------+
| 2010-03-26                              |
+-----------------------------------------+
Was this article useful?