Problem with timezones

From: Kay-Uwe Genz <kug1977(at)web(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem with timezones
Date: 2003-06-24 18:46:21
Message-ID: 25E89968-A674-11D7-9D5A-000A27B51AF2@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I've created a table with a column 'utc time with time zone' and then
INSERT '0:00:00 XXX' where XXX is the tiemzone.

In the table are all timezones and if I select with

SELECT (timezone_hour FROM utc) FROM timezones;

PostGreSQL return all timeszones with sign (example for IDLW it should
be -12; 12 is returned).

Is this a bug or is this me mistake?

I've PostGreSQL Version 7.3.2 running on a Mac OS X 10.2 (G3).

Thanks for help.

Kay-Uwe Genz

Browse pgsql-bugs by date

  From Date Subject
Next Message Kay-Uwe Genz 2003-06-24 18:47:36 Problem with timezones
Previous Message Enke, Michael 2003-06-24 18:28:24 Re: [HACKERS] again: Bug #943: Server-Encoding from EUC_TW