Hi All,
I have stored event records in Postgresql 7.3.4 and now need to calculate the duration between each event in succession. I have "record_id" and a" timestamp without time zone" columns for each event.
What is a good way to calculate the difference in timestamp and store it in the record as duration. I am doing this as part of a java application on RH linux 8.0.
My timestamp is of the form "2005-01-30 07:51:29.149458". thanks in advance, Phil
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
