How to get date interval?(m40)

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?


Ans:

You can use date datatype

select to_char(sum(interval),'HH:MM:SS') from table;

just test this format
by giving select to_char(sysdate,'HH:MM:SS') from dual
 

Hosted by www.Geocities.ws

1