Re: Elapsed Time
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: DGoulet@xxxxxxxx
- Date: Fri, 19 May 2006 21:14:08 +0200
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@xxxxxxxx>:
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
--
//www.freelists.org/webpage/oracle-l
--
Best regards,
Alex Gorbachev
http://oracloid.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
