| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | extract(timezone_hour) funny business |
| Date: | 2001-10-10 16:57:34 |
| Message-ID: | Pine.LNX.4.30.0110100104320.672-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2001-10-10 17:28:19 | Re: [HACKERS] Unicode combining characters |
| Previous Message | Peter Eisentraut | 2001-10-10 16:52:46 | Re: Encoding issues |