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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Torello Querci <querci(at)negens(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Date: 2003-09-10 16:25:38
Message-ID: 7660.1063211138@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Torello Querci <querci(at)negens(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Theodore Petrosky 2003-09-10 16:34:31 Re: help with mac osx 10.2.6
Previous Message Torello Querci 2003-09-10 15:44:13 Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.