【数据库】更新时间日期，而不修改小时，分钟
UPDATE t_security_in_out_record_sta set traffic_time = ADDTIME (date('2022-01-27') + interval 0 hour,time(traffic_time)) WHERE traffic_time like "2022-01-25%"
posted on 2022-01-27 14:13 littlefive 阅读(77) 评论(0) 编辑 收藏 举报
UPDATE t_security_in_out_record_sta set traffic_time = ADDTIME (date('2022-01-27') + interval 0 hour,time(traffic_time)) WHERE traffic_time like "2022-01-25%"
posted on 2022-01-27 14:13 littlefive 阅读(77) 评论(0) 编辑 收藏 举报