Re: BUG #3816: Timezone bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3816: Timezone bug
Date
Msg-id 8274.1197650114@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3816: Timezone bug  ("Geert Bijloos" <geert.bijloos@aeronomie.be>)
List pgsql-bugs
"Geert Bijloos" <geert.bijloos@aeronomie.be> writes:
> 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

On what grounds do you claim that that's wrong?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug (#3484) - Invalid page header again
Next
From: Zdenek Kotala
Date:
Subject: Re: Bug (#3484) - Invalid page header again