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

2003-09-13 Thread Torello Querci
'); > > you were casting the string to a date and returning a > date. so it would return it in a format that your > system is set to return. > > agencysacks=# select > to_char('03/06/1973'::date,'dd/mm/yyyy'); > to_char > ---

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

2003-09-13 Thread Torello Querci
timestamp 1973-06-04 00:00:00+02 Alle 15:33, mercoledì 10 settembre 2003, hai scritto: > 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

[BUGS] Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.

2003-09-10 Thread 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/'); 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