MySQL Date Add date time Date_add () function

The Date_add () function adds the specified time interval to the date.

Grammar
Date_add (Date,interval expr type) The date argument is a valid datetime expression. The expr parameter is the time interval that you want to add.

The type parameter can be the following values:

Type 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

Instance One
Add Days
MySQL Tutorials > select Date_add (curdate (), INTERVAL 1 day);
+-------------------------------------+
| Date_add (Curdate (), INTERVAL 1 day) |
+-------------------------------------+
| 2007-07-23 |
+-------------------------------------+
1 row in Set (0.00 sec)

Plus minutes

Mysql>
Mysql> Select Date_add (curdate (), INTERVAL 1 MINUTE);
+----------------------------------------+
| Date_add (Curdate (), INTERVAL 1 MINUTE) |
+----------------------------------------+
| 2007-07-22 00:01:00 |
+----------------------------------------+
1 row in Set (0.00 sec)

Mysql>

Number of years added

Mysql>
Mysql> Select Date_add (curdate (), INTERVAL 1 year);
+--------------------------------------+
| Date_add (Curdate (), INTERVAL 1 year) |
+--------------------------------------+
| 2008-07-22 |
+--------------------------------------+
1 row in Set (0.00 sec)

Mysql>

Plus when I was a kid

Mysql>
Mysql> Select Date_add (curdate (), INTERVAL 1 HOUR);
+--------------------------------------+
| Date_add (Curdate (), INTERVAL 1 HOUR) |
+--------------------------------------+
| 2007-07-22 01:00:00 |
+--------------------------------------+
1 row in Set (0.00 sec)

Mysql>