| From: | "Geert Bijloos" <geert(dot)bijloos(at)aeronomie(dot)be> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #3816: Timezone bug |
| Date: | 2007-12-14 15:54:24 |
| Message-ID: | 200712141554.lBEFsOS1045322@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3816
Logged by: Geert Bijloos
Email address: geert(dot)bijloos(at)aeronomie(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-12-14 16:28:02 | Re: Bug (#3484) - Invalid page header again |
| Previous Message | alex | 2007-12-14 12:22:43 | Bug (#3484) - Invalid page header again |