time calculation - Mailing list pgsql-general

From qradius@qnet.com.pe
Subject time calculation
Date
Msg-id 200111291510.fATFAcm73179@postgresql.org
Whole thread Raw
List pgsql-general
Dear sirs:

Please I need to solve this problem:

I need to sustract two values timestamp type and return the
difference in seconds, exists some funciton on postgresql for
do this?

e.g:

I have value1='2001-10-01 12:50:13' and value2='2001-09-10
12:53:10'

I need to calculate value1-value2 and return how many seconds
there are between both timestamps.

thank you

Ernesto

---------------------------------------------
Este mensaje fue enviado a trav�s de Qnet
http://www.qnet.com.pe



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem in 'select' from temp table with Perl/DBI
Next
From: Antonio Fiol Bonnín
Date:
Subject: Re: time calculation