"Reiro" <ReiroGP@gmail.com> wrote in news:1143211729.506918.134210
@g10g2000cwb.googlegroups.com:

> Hi
>
> I have a test table. 1 of the columns hav time in second as follows
:
>
> Seconds
>
> 10720
> 31
> 30
> 31
> 30
> 11
> 20
> 10
> 4
> 2459
>
> I want the data in a new column T in hh24:mm:ss
>
> plz help
>
> thanks in advance
>
>

ALTER TABLE.......

Are you incapable or unwilling to RTFM?

http://download-west.oracle.com/docs/cd/B10501_
01/server.920/a96540/statements_32a.htm#2054899