Kevin,
There is a script named uptime.sql on the OrioleCorp site which does
something similar, can be a good starting point.
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
>
> Hi List.
>
> I have a SQL question that should be fairly easy, but I haven't quite gotten
> it nailed down yet.
>
> I am storing the in_date for a particular record. I need to calculate the
> number of days, hours, and minutes that have elapsed since the record was
> entered.
>
> It should look something like this:
>
> RECORD AGE
> --------------- --------
> Item1 2 Days, 9 Hours, 32 Minutes
>
>
> If any of you has done something similar, would you mind sharing your
> solution or steering me in the right direction?
>
> Thanks.
> -km
>
> --
> Author: Kevin Martin
> INET: kevin.martin_at_catapultsystems.com
Received on Mon May 15 2000 - 03:58:54 CDT
