The following bug has been logged online: Bug reference: 3816 Logged by: Geert Bijloos Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 and 8.2.4 Operating system: Linux Description: Timezone bug Details:
Try this SET TIMEZONE TO 'CET'; SELECT (timestamp with time zone '2000-01-01 UT' + interval '86 days 0 hours 5 min 0 sec') at time zone 'UT'; "2000-03-26 23:05:00" -> WRONG SET TIMEZONE TO 'UTC'; SELECT (timestamp with time zone '2000-01-01 UT' + interval '86 days 0 hours 5 min 0 sec') at time zone 'UT'; "2000-03-27 00:05:00" -> RIGHT It can be reproduced for several timezones. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
