Timestamps and computing aggregate time.

From: Bob <rgants1_at_aol.com>
Date: 3 Jun 2004 09:55:37 -0700
Message-ID: <ee9df281.0406030855.15cd2121@posting.google.com>

thanks in advance,

I am using Oracle 9i. I am looping through records via plsql and subtracting 2 timestamp datatypes.

myTime := (disconTime - startTime);

my problem is I dont understand how to get an aggregated variable out of myTime. What I want is a total amount of time used. I would like to be able to get it in minutes if possible.

so for example what I get as output from the above is as follows:

+000000000 00:01:01.400000
+000000000 00:01:45.500000
+000000000 00:00:19.700000
+000000000 00:09:38.200000
+000000000 00:01:18.800000
+000000000 00:00:34.100000
+000000000 00:00:43.500000
+000000000 00:01:12.100000
+000000000 00:01:04.500000
+000000000 00:03:00.800000
+000000000 00:02:12.200000

how can I add these up for a grand total of time used? Received on Thu Jun 03 2004 - 11:55:37 CDT