Add three days to the current date and change the number of days:
SELECT Date_add (Current_date (), Interval 3 day);
Add three days to the specified date:
SELECT date_add (' 2014-04-17 ', Interval 3 day);
-2014-04-20
Add a time to the specified time:
As in "January 1, 2012 two o'clock" plus Sparing 10 seconds MySQL statement is:
Select Date_add (' 2014-04-17 2:00:00 ', Interval ' 1:10:10 ' Hour_second);
--2014-04-17 3:10:10
Select Date_add (date, Interval 1 day); Date plus Day
Select Date_add (date, interval 1 hour); Date plus Hour
Select Date_add (date, interval 1 minute); Date plus points
Select Date_add (date, interval 1 second); Date plus seconds
Select Date_add (date, interval 1 microsecond); Date plus microseconds
Select Date_add (date, interval 1 week); Date Plus Week
Select Date_add (date, interval 1 month); Date Plus Month
Select Date_add (date, interval 1 quarter); Date plus Quarter
Select Date_add (date, interval 1 year); Date plus Year
MySQL date plus days, hours, minutes ... Get a new time