Re: Date Conversion Bug

Ayal Leibowitz (ayal(at)modelity(dot)com) writes:
> I encountered this bug in Postgres version 6.5 to 7.1 and on RedHat Linux versions 6.1 to 7.1.

Several of the developers have tried to reproduce this bug, with no
success.

> select date('1993-04-02') from xxx;
> I get 1993-04-01 for each line in xxx.
> My default time zone is GMT+2.

Exactly how do you set the time zone? What does "SHOW TIMEZONE" show?
What do you get from
select timestamp('1993-04-01');
select timestamp('1993-04-02');
select timestamp('1993-04-03');

> Like specified in #249, it happens only on the switch from normal to
> daylight saving time.

One reason I'm so interested in your timezone is that 1993-04-02 is not
a DST transition day in any timezone that I know about. In Europe, DST
transitions happen in the last week of March, never in April, according
to the references I can find. In the USA, we do have transitions in
April, but the transition day in 1993 was 04-04.

regards, tom lane