days_add
Description
Syntax:
DATETIME DAYS_ADD(DATETIME date, INT days)
This function adds the specified days to the DATE or DATETIME.
data
can be of DATE or DATETIME type and the returned result is of the same type of date
.
Example
mysql> select days_add(to_date("2020-02-02 02:02:02"), 1);
+---------------------------------------------+
| days_add(to_date('2020-02-02 02:02:02'), 1) |
+---------------------------------------------+
| 2020-02-03 |
+---------------------------------------------+
Keywords
DAYS_ADD