MySQL Update table in date field time

The date_add and date_sub functions can be added and reduced using the time interval identified by the interval keyword, similar to the Strtotime function in PHP.

1. Update the validity period of the Table Valid_time field value is increased by one day

UPDATE cqh_activity SET Valid_time=date_add (valid_time,interval 1 day);

2. Update the validity period of the table Valid_time field values are reduced by one day

UPDATE cqh_activity SET valid_time=date_sub (valid_time,interval 1 day);

MySQL Update table in date field time