Not sure what this question has to do with DBA or Oracle at all...
In pseudo language:
x = <so many seconds>
h = round( x / 60 / 60 )
m = round ( (x - h*60*60) / 60 ) or m = round ( x / 60 - h * 60)
s = x - h * 60 * 60 - m * 60
It's from the top of my head so might be a mistake somewhere.
2006/5/19, Goulet, Dick <DGoulet_at_vicr.com>:
> Folks,
>
> Before I go off re-inventing the wheel, and yes I still have to
> scan AskTom, but here's by "problem".
>
> I've a developer who has calculated the elapsed time of some
> database action, whatever it is, and he wants to display the result to
> the user, but not as a pile of seconds. He wants to convert it into
> hours, minutes, and seconds so that the display comes out as a character
> string looking like
> "x hours y minutes z seconds". Anyone done that before.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified DBA
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Best regards,
Alex Gorbachev
http://oracloid.blogspot.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 19 2006 - 14:14:08 CDT
