Postgres Pro
Downloads
Home   >   mailing lists

Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2. - Mailing list pgsql-bugs

From Torello Querci
Subject Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Date
Msg-id 200309101252.22929.querci@negens.com
Whole thread Raw
Responses Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.  (Karel Zak <zakkr@zf.jcu.cz>)
Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.  (Daniel Schreiber <daniel.schreiber@s1999.tu-chemnitz.de>)
Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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?

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 7.4 beta 2: COPY IN, arrays, and double quotes bug.
Next
From: Pavel Stehule
Date:
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.