extract(timezone_hour) funny business - Mailing list pgsql-hackers

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@gmx.net   http://funkturm.homeip.net/~peter