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
PGP.sig
Description: PGP signature
