Re: Formatting count of seconds to date format using SQL?
From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Tue, 14 Dec 1999 16:17:56 GMT
Message-ID: <835qjf$8t1$1_at_nnrp1.deja.com>
Date: Tue, 14 Dec 1999 16:17:56 GMT
Message-ID: <835qjf$8t1$1_at_nnrp1.deja.com>
Jan-Helge, give this at try.
SELECT TO_CHAR(FLOOR(:secnds*(1/24/60/60)),'00') || TO_CHAR(((TRUNC(SYSDATE))) + (:secnds*(1/24/60/60)), ' HH24:MI:SS') FROM dual ;
HTH
James
In article <3856503F.49DC7BA1_at_protek.no>,
Jan-Helge Bergesen <jhb_at_protek.no> wrote:
> Hi again.
>
> Thanks for your help!
>
> I was hoping to avoid having to create a function in the database for
> this,
> but if you gotta - you gotta.
>
> --
> Jan-Helge Bergesen +4755225759
> Protek TELsoft
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Dec 14 1999 - 17:17:56 CET