Timestamps and computing aggregate time.
Date: 3 Jun 2004 09:55:37 -0700
Message-ID: <ee9df281.0406030855.15cd2121_at_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 - 18:55:37 CEST