[BUGS] Problem with timezones

2003-06-28 Thread Kay-Uwe Genz
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 shoul

Re: [BUGS] Problem with timezones

2003-06-27 Thread Tom Lane
Kay-Uwe Genz <[EMAIL PROTECTED]> writes: > Is this a bug or is this me mistake? Yours I think. Type TIME WITH TIME ZONE stores a time of day (from 00:00:00 to 23:59:59) plus a time zone (some offset east or west of Greenwich --- I think we allow up to plus or minus 13 hours). I see nothing in th

[BUGS] Problem with timezones

2003-06-27 Thread Kay-Uwe Genz
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 shoul