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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
