# TIMESTAMPADD

Adds the given interval of time to a date or datetime object

## Syntax

```
TIMESTAMPADD ({YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MICROSECOND}, num, dateobj)

```

## Arguments

* num: the number of units to add. Can be negative
* dateobj: a valid date, datetime, or parsable date string

## Return Type

Time object. If dateobj is not a valid time, returns NULL.

## Examples

```sql
SELECT TIMESTAMPADD(YEAR, 6, '2009-02-13 23:31:30');

```

```output

+----------------------------------------------+
| TIMESTAMPADD(YEAR, 6, '2009-02-13 23:31:30') |
+----------------------------------------------+
| 2015-02-13 23:31:30                          |
+----------------------------------------------+

```

**Related Topics**

* [TIMESTAMP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timestamp.md)
* [TIMESTAMPDIFF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timestampdiff.md)

***

Modified at: May 31, 2023

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/timestampadd/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/timestampadd/)

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