请教一个SQL语句

[carefree_fish]

QDJHSJ
18:39
18:47
17:50
21:20

QDJHSJ是文本型的，我要给这个字段的值都加上1分钟，SQL语句怎么写？？

[ngx20080110]

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 

[Diza1986]

--日期类型加的是天数
update tb set QDJHSJ = to_char(to_date(QDJHSJ,'HH24:MI') + 1/(24*60),'HH24:MI')

[gelyon]

update table_name set QDJHSJ = to_char(to_date(QDJHSJ,'HH24:MI') + 1/(24*60),'HH24:MI');

[氧气网航]

[Quote=引用 3 楼 gelyon 的回复:]
SQL code


update table_name set QDJHSJ = to_char(to_date(QDJHSJ,'HH24:MI') + 1/(24*60),'HH24:MI');
[/Quote]
这个正确

[xiaobn_cn]

1，2，3楼都是正解，个人比较喜欢1楼的算法。

[心中的彩虹]

[Quote=引用楼主 carefree_fish 的回复:]
QDJHSJ
18:39
18:47
17:50
21:20

QDJHSJ是文本型的，我要给这个字段的值都加上1分钟，SQL语句怎么写？？
[/Quote]

select to_date(qdjhsj,'hh24:mi:ss')+1/(24*60) from tb

[huangyunzeng2008]

日期直接加1 是一天的意思，可以换算一下，OK！