Re: Seconds

From: Jim Kennedy <jim>
Date: Fri, 24 Mar 2006 06:59:36 -0800
Message-ID: <zZadnXr5-OhNlbnZRVn-vA@comcast.com>

"Reiro" <ReiroGP_at_gmail.com> wrote in message news:1143211729.506918.134210_at_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 :)
>

There is a date field which includes the time of the day. Is the seconds the number of seconds since midnight? If so then alter table xyz add (mydate_col date);

update xyz set
mydate_col=to_date('1/1/2006','mm/dd/yyyy')+(seconds/(24*60*60)); commit;
Then it would be all as of 1/1/2006. I don't know if that is what you want. Jim Received on Fri Mar 24 2006 - 08:59:36 CST