Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.

From: Torello Querci <querci(at)negens(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Date: 2003-09-10 10:52:22
Message-ID: 200309101252.22929.querci@negens.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi to all,

I have a problem storing 1973/06/03 date.

If I send this statement

select to_date('03/06/1973','dd/mm/yyyy');

in the psql interface I obtain

to_date
------------
1973-06-02

I test this statement with Postgres 7.3.2 and 7.3.4 packaged withMandrake 9.1
and Mandrake 9.2RC1 and obtain the same result.

Can anyone help me?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2003-09-10 13:05:05 Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Previous Message Tom Lane 2003-09-10 06:39:01 Re: PG 7.4 beta 2: COPY IN, arrays, and double quotes bug.