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,
pgsql-novice by date
|Next:||From: Arthur van Dorp||Date: 2005-02-04 15:34:56|
|Subject: Re: [despammed] Re: Using a preprocessor for constants in|
|Previous:||From: Andreas Kretschmer||Date: 2005-02-04 14:38:37|
|Subject: Re: [despammed] Re: Using a preprocessor for constants in SQL|