Best way to convert seconds to hours:minutes:seconds
- From: b_addams@xxxxxxxxx
- Date: 29 Dec 2006 13:16:26 -0800
I have a table that stores elapsed seconds as a numeric value. There is
a PHP script that displays data from this table onto a web page. What
is the best way to display the elapsed time in an HH:MI:SS format?
Obviously the to_char function only works on dates, so I am not sure
how to go about this. Do I need to create an internal PL/SQL function
that is called from my PHP SQL?
Thanks.
.
- Follow-Ups:
- Re: Best way to convert seconds to hours:minutes:seconds
- From: Michel Cadot
- Re: Best way to convert seconds to hours:minutes:seconds
- Prev by Date: Re: Oracle Application Server Upgrade Impact?
- Next by Date: Re: Best way to convert seconds to hours:minutes:seconds
- Previous by thread: Oracle Application Server Upgrade Impact?
- Next by thread: Re: Best way to convert seconds to hours:minutes:seconds
- Index(es):