peter=# select current_timestamp;
timestamptz
-------------------------------
2001-10-10 01:04:54.965162+02
(1 row)
peter=# select extract(timezone_hour from current_timestamp);
date_part
-----------
-2
(1 row)
Plus or minus?
peter=# select extract(timezone_hour from timestamp '2001-10-10 01:04:54.965162+02');
date_part
-----------
-2
(1 row)
(Same problem)
peter=# select extract(timezone_hour from timestamp '2001-10-10 01:04:54.965162+03');
^^
date_part
-----------
-2
(1 row)
Big problem.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter