--将log_time中不为0点整的记录全部更新为0点整
UPDATE test
SET log_time = (
to_timestamp(
(
to_char(log_time, 'yyyy-mm-dd') || ' 00:00:00'
),
'yyyy-mm-dd HH24:MI:SS'
) AT TIME ZONE 'UTC-8'
)
WHERE
to_char(
log_time,
'yyyy-mm-dd hh24:mi:ss'
) NOT LIKE '%00:00:00'