Elapsed time between timestamp variables in Function

From: "Nico Callewaert" <callewaert(dot)nico(at)telenet(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Elapsed time between timestamp variables in Function
Date: 2009-02-04 21:59:17
Message-ID: EB846396B3254BAD98E7DB7BDE2AFEF6@etsinformatics.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi !

I saw previous postings about elapsed time between 2 timestamps, using SELECT EXTRACT...
I have similar question, but it's not in a select statement, but between 2 variables in a function.

To keep it simple, I have 2 variables, let's say A and B, both TimeStamp. Now I would like to know the absolute value of elapsed seconds between the 2 timestamps. Has to be absolute value, because can be positive or negative, depends if A > B or A < B.
I tried with age(A, B), but that gives me something like 00:00:01, not really numeric value for number of seconds.

Many thanks in advance !
Nico

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Rich 2009-02-04 22:18:23 Re: ramblings about password exposure (WAS: field with Password)
Previous Message Peter Eisentraut 2009-02-04 21:27:19 Re: Which is best, timestamp as float or integer ?