请教个SQL语句

[carefree_fish]

有一些文本型的时间数据
00:00
01:10
02:30
00:35
……
怎么让前面两位都加上24，变成
24:00
25:10
26:30
24:35

请问该怎么写呢？

[zhangji2411]

SELECT (to_number(substr('03:33',1,2))+24)||(substr('00:03',3,3)) FROM dual;

[zhangji2411]

SELECT (to_number(substr('03:33',1,2))+24)||(substr('03:33',3,3)) FROM dual;

[carefree_fish]

谢谢楼上的