MySQL add days to a date in database table

Written by khawaib

Topics: SQL

To increase dates in database table run following query and change INTERVAL value to desired value.

UPDATE `table_name` SET `date` = DATE_ADD(`date` , INTERVAL 365 DAY);

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.