# DATE\_SUB

Subtracts the given interval of time to a date or datetime object.

## 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](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/date-add.md) 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);

```

```output

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

```

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/date-sub/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/date-sub/)

(An index of the documentation is available at /llms.txt)