VeloDB Cloud
SQL Manual
Functions
date-time-functions
days_add

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