with tmp as ( select '18:39' qdjhsj from dual union all select '18:47' qdjhsj from dual union all select '17:50' qdjhsj from dual union all select '21:20' qdjhsj from dual) select qdjhsj, to_char(to_date(qdjhsj, 'hh24:mi') + interval '1' minute, 'hh24:mi') after_1_min from tmp;QDJHSJ AFTER_1_MIN ------- ----------- 18:39 18:40 18:47 18:48 17:50 17:51 21:20 21:21
--日期类型加的是天数 update tb set QDJHSJ = to_char(to_date(QDJHSJ,'HH24:MI') + 1/(24*60),'HH24:MI')
update table_name set QDJHSJ = to_char(to_date(QDJHSJ,'HH24:MI') + 1/(24*60),'HH24:MI');
select to_date(qdjhsj,'hh24:mi:ss')+1/(24*60) from tb
with tmp as
(
select '18:39' qdjhsj from dual union all
select '18:47' qdjhsj from dual union all
select '17:50' qdjhsj from dual union all
select '21:20' qdjhsj from dual)
select qdjhsj, to_char(to_date(qdjhsj, 'hh24:mi') + interval '1' minute, 'hh24:mi') after_1_min
from tmp;QDJHSJ AFTER_1_MIN
------- -----------
18:39 18:40
18:47 18:48
17:50 17:51
21:20 21:21
--日期类型加的是天数
update tb set QDJHSJ = to_char(to_date(QDJHSJ,'HH24:MI') + 1/(24*60),'HH24:MI')
select to_date(qdjhsj,'hh24:mi:ss')+1/(24*60) from tb