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”