INTERVAL 用法

update A001001001001    set data_download_time = data_download_time + INTERVAL '8' HOUR  where TO_DATE(to_char(entrydate, 'yyyy-MM-dd') || ' ' || entrytime,'yyyy-MM-dd HH24:mi:ss') > data_download_time            ;

 

posted @ 2022-02-19 15:56  rjm123456  阅读(122)  评论(0编辑  收藏  举报