Eric wrote in message <7epaqn$gcg$1_at_camel21.mindspring.com>...
>I need to keep track of how long various system process execution times. In
>my source code, I have an object that knows the start time and the end time
>of a process, and I have an Interval object that can calculate the
>difference between the two.
>
>Ideally, I want to be able to store one value representing this interval in
>Oracle (7.3 server), which I can later retieve and format as
>hour:min:seconds in Brio Query. I want to be able to total these values as
>well, and display the total formatted as hour:min:seconds as well.
>
>Can I do this? What Oracle datatype should I use, and how should it be
>populated?
>
>Any advice much appreciated!
>
>Eric
>
>
If you need elapsed time in 1/100 seconds you can get this through
DBMS_UTILITY.GET_TIME.
HTH.
Finn
Received on Tue Apr 13 1999 - 04:35:41 CDT
