UPDATE t_cpzs_code
SET production_time = ADDTIME(
date('2018-11-01') + INTERVAL 3 HOUR,
time(production_time)
) WHERE equipment_name='15#'
mysql 在当前时间上加几小时
最新推荐文章于 2024-05-26 15:12:40 发布
UPDATE t_cpzs_code
SET production_time = ADDTIME(
date('2018-11-01') + INTERVAL 3 HOUR,
time(production_time)
) WHERE equipment_name='15#'