Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Elapsed Time

Re: Elapsed Time

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 19 May 2006 11:05:55 -0700
Message-ID: <bf46380605191105r7cd658ela528d26bc80a828d@mail.gmail.com>


Here's an example to play with:

select

   last_call_et,

On 5/19/06, Goulet, Dick <DGoulet_at_vicr.com> wrote:
>
> 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
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 19 2006 - 13:05:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US