DATE_ADD

This function performs add date arithmetic. The given integer is added to the day part of the given date or timestamp. A negative expression subtracts the number from the given date or timestamp.

Syntax

DATE_ADD(date, value)

Example

SELECT DATE_ADD('2018-05-02', 1)

The above query returns “2018-05-03”

 

SELECT DATE_ADD('2018-05-02', -1)

The above query returns “2018-05-01”