From: | Antonio Fiol Bonnín <fiol(at)w3ping(dot)com> |
---|---|
To: | qradius(at)qnet(dot)com(dot)pe |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: time calculation |
Date: | 2001-11-29 16:06:50 |
Message-ID: | 3C065D1A.3BAC7201@w3ping.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
extract ( epoch from (value1-value2) )
qradius(at)qnet(dot)com(dot)pe wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Earl | 2001-11-29 17:08:02 | Re: Licensing |
Previous Message | Tom Lane | 2001-11-29 15:02:51 | Re: Problem in 'select' from temp table with Perl/DBI |