MySQL time add function date_add ()

The Date_add () function in MySQL

1. Definition: The function adds the specified time interval to the date.

2. Syntax: Date_add (date,interval expr type)

The date parameter is a valid day expression. The expr parameter is the time interval that you want to add.

The type parameter can be the following value:

Microsecond
SECOND
MINUTE
HOUR
Day
WEEK
MONTH
QUARTER
Year
Second_microsecond
Minute_microsecond
Minute_second
Hour_microsecond
Hour_second
Hour_minute
Day_microsecond
Day_second
Day_minute
Day_hour
Year_month

3. Example:

Select Now ();

#2018-08-13 22:44:28

Select Date_add (now (), INTERVAL 2 day);

#2018-08-15 22:44:28

MySQL time add function date_add ()