2009/2/4 Nico Callewaert <callewaert.nico@xxxxxxxxxx>: > 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 EXTRACT(EPOCH FROM age(A,B)) ? Osvaldo -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
