Timestamps and computing aggregate time.

From: Bob <rgants1_at_aol.com>
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

This message: [ Message body ]
Next message: Ed prochak: "Re: Trigger to delete record from one table with check on another table."
Previous message: Carlos Ibarra: "Unindexed foreign keys and full table scans"
Next in thread: Bob: "Re: Timestamps and computing aggregate time."
Reply: Bob: "Re: Timestamps and computing aggregate time."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message