MySQL Code for adding days, time to date column

by

Use following code to update a date column in MySQL table. One can add days, hours and more depending on the requirement. A fix date can be provided (like 2023-06-20) to which days can be added, current date can be used to add days, existing date_column value can also be used to add days, based on other column value like serial number or some number can be added.

using fix date

UPDATE table_name SET date_column= ‘2023-06-20’ + INTERVAL 2 DAY + INTERVAL 19 HOUR;

using current date

UPDATE table_name SET date_column=CURDATE() + INTERVAL 2 DAY + INTERVAL 19 HOUR;

using column date

UPDATE table_name SET date_column= date_column + INTERVAL 2 DAY + INTERVAL 19 HOUR;

using column value

UPDATE table_name SET date_column= ‘2023-06-20’ + INTERVAL column_name DAY + INTERVAL 19 HOUR;

Leave a Comment