Skip site navigation (1) Skip section navigation (2)

BUG #3816: Timezone bug

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 (view raw or flat)
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.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-12-14 16:28:02
Subject: Re: Bug (#3484) - Invalid page header again
Previous:From: alexDate: 2007-12-14 12:22:43
Subject: Bug (#3484) - Invalid page header again

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group