Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Seconds
"Reiro" <ReiroGP_at_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 Received on Fri Mar 24 2006 - 08:55:56 CST