DATE_SUB

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Syntax

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

Arguments

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.

Examples

SQL

SELECT DATE_SUB('2010-04-02', INTERVAL 1 WEEK);

+-----------------------------------------+
| DATE_SUB("2010-04-02", INTERVAL 1 WEEK) |
+-----------------------------------------+
| 2010-03-26                              |
+-----------------------------------------+