How To Increment Dates by 1 Day in MySQL ?

If you have a date, and you want to increment it by 1 day, you can use the DATE_ADD(date, INTERVAL 1 DAY) function. You can also use the date interval add operation as “date + INTERVAL 1 DAY. Examples:

SELECT DATE_ADD(DATE('2017-01-28'), INTERVAL 1 DAY)
   FROM DUAL;
   2017-01-29

SELECT DATE('2017-01-31') + INTERVAL 1 DAY FROM DUAL;
   2017-02-01