mysql修改时间日期，时分秒不变

update table_name set column_name = addtime(date('2020-11-19')+internal 0 hour,time(column_name)) 

where file_name between 'xxx' and 'xxx';

mysql修改时间日期，时分秒不变，方便查看