Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Date
Msg-id 7660.1063211138@sss.pgh.pa.us
Whole thread Raw
In response to Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.  (Torello Querci <querci@negens.com>)
List pgsql-bugs
Torello Querci <querci@negens.com> writes:
> 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

What timezone are you in?  What do you get from
    select to_timestamp('03/06/1973','dd/mm/yyyy');

            regards, tom lane

pgsql-bugs by date:

Previous
From: Daniel Schreiber
Date:
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Next
From: Theodore Petrosky
Date:
Subject: Re: help with mac osx 10.2.6