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

On Wed, Sep 10, 2003 at 12:52:22PM +0200, 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?

 What's happen if you try:

test=# select '03/06/1973'::date;
    date
------------
 1973-06-03


--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/