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;