update table t set t.time = decode(t.time,'',t.time,to_char(to_date(t.time, 'hh24:mi')+numtodsinterval(:times, 'minute'),'hh24:mi'))
oracle sql 加减时间
最新推荐文章于 2023-02-09 17:34:11 发布
update table t set t.time = decode(t.time,'',t.time,to_char(to_date(t.time, 'hh24:mi')+numtodsinterval(:times, 'minute'),'hh24:mi'))