DAYS_ADD
days_addβ
descriptionβ
Syntaxβ
DATETIME DAYS_ADD(DATETIME date, INT days)
From date time or date plus specified days
The parameter date can be DATETIME or DATE, and the return type is consistent with that of the parameter 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