The following bug has been logged online:
Bug reference: 3816
Logged by: Geert Bijloos
Email address: geert.bijloos@aeronomie.be
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.