Search Postgresql Archives

Re: Calculating the difference between timetz values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jul 27, 2009, at 6:52 PM, Michael Glaesemann wrote:

On Jul 27, 2009, at 10:54 , Alexey Klyukin wrote:

Hello,

I was looking for a way to get the difference (interval) between 2 timetz values, i.e.:
I don't have a solution, but am curious what your use case is for  
timetz (as opposed to timestamptz).
I'm writing a custom trigger function that has to compare values of  
time* types and make some actions depending on a result.
Answering my own question, Alvaro proposed a solution with  
extract(epoch from tz_value), the result is in seconds:
postgres=# select extract(epoch from '00:00:00+0'::timetz) -  
extract(epoch from '2:00:00+2'::timetz);
 ?column?
----------
        0
(1 row)

--
Alexey Klyukin       http://www.CommandPrompt.com
The PostgreSQL Company - Command Prompt, Inc.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux