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

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Torello Querci <querci(at)negens(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Date: 2003-09-10 13:05:05
Message-ID: Pine.LNX.4.44.0309101503090.22500-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On my 7.4 this select works fine

testdb011=> select to_date('03/06/1973','dd/mm/yyyy');
to_date
------------
1973-06-03

Pavel

On Wed, 10 Sep 2003, Torello Querci wrote:

> 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?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Karel Zak 2003-09-10 13:33:02 Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Previous Message Torello Querci 2003-09-10 10:52:22 Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.