Re: BUG #5050: text to timestamp failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Aoyai Kouhei" <aoyagi(dot)kouhei(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5050: text to timestamp failure
Date: 2009-09-12 19:58:20
Message-ID: 11358.1252785500@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Aoyai Kouhei" <aoyagi(dot)kouhei(at)gmail(dot)com> writes:
> select '0001-01-01'::timestamp with time zone;
> -> "0001-01-01 00:00:00+09:18:59"

> select '1887-01-01'::timestamp with time zone;
> -> "1887-01-01 00:00:00+09:18:59"

You did not say what timezone setting you are using, but in some of them
this is not wrong.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message the6campbells 2009-09-12 23:13:41 BUG #5051: SQLNumResultCols returns 0 for common table expression
Previous Message Aoyai Kouhei 2009-09-12 15:49:22 BUG #5050: text to timestamp failure