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])