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

Am Mittwoch, 10. September 2003 12:52 schrieb Torello Querci:
> 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?

Could be Mandrake or compiler problem.
# select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.3.2 on i386-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)

# select to_date('03/06/1973','dd/mm/yyyy');
  to_date
------------
 1973-06-03
(1 row)

This is on Debian woody with backported postgres from testing.

HTH,
Daniel
--
Daniel Schreiber | ICQ: 220903493
GPG encrypted Mail welcome! Key ID: 25A6B489
Chemnitzer Linux-Tag:
http://www.tu-chemnitz.de/linux/tag/