Ayal Leibowitz (ayal@modelity.com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Date Conversion Bug
Long Description
Hi,
I encountered this bug in Postgres version 6.5 to 7.1 and on RedHat Linux versions 6.1 to 7.1.
It's similar or even identical to bugs #208 and #249, but I want to clarify a little more.
It looks like Postgres refers to the time zone when converting character string to date type. For example, when I type:
select date('1993-04-02') from xxx;
I get 1993-04-01 for each line in xxx.
My default time zone is GMT+2. If I type: set time zone 'gmt'; before the above query the result is as expected:
1993-04-02.
To my understanding, date shouldn't be influenced by the time zone, only the time and timestamp types. This is the
reasonwhy the newly version 7.1 "WITHOUT TIME ZONE" type qualifier does not relate to the date type.
Like specified in #249, it happens only on the switch from normal to daylight saving time.
Ayal Leibowitz,
Modelity Technologies.
Sample Code
select date('1993-04-02') from xxx;
results with 1993-04-01 in psql.
No file was uploaded with this report