update VEHICLE_MATERIAL set CREATE_TIME=to_timestamp('2025'||'-'||to_char(CREATE_TIME,'mm')||'-'||to_char(CREATE_TIME,'dd')||' '
||to_char(CREATE_TIME,'hh')||':'||to_char(CREATE_TIME,'mi')||':'||to_char(CREATE_TIME,'ss'),'YYYY-mm-dd hh24:mi:ss')
更改时间类型只改变年,其他不变
于 2022-06-13 17:17:43 首次发布