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
> 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to