- sql
-- 两种将字符串转化成日期的时间是24小时的格式
UPDATE BO_EU_HTQC SET HTQDSJ = TO_DATE('2021-11-15 15:00:00','yyyy-MM-dd hh24:mi:ss') WHERE HTBH = 'G1000120210924-009'
UPDATE BO_EU_HTQC SET HTQDSJ = TO_DATE('2021-11-15 16:00:00','yyyy-MM-dd HH24:MI:ss') WHERE HTBH = 'G1000120210924-009'
-- 修改成12小时制 会报错
UPDATE BO_EU_HTQC SET HTQDSJ = TO_DATE('2021-11-15 15:00:00','yyyy-MM-dd hh:mi:ss') WHERE HTBH = 'G1000120210924-009'