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
