Re: BUG #5050: text to timestamp failure - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5050: text to timestamp failure
Date
Msg-id 11358.1252785500@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5050: text to timestamp failure  ("Aoyai Kouhei" <aoyagi.kouhei@gmail.com>)
Responses Re: BUG #5050: text to timestamp failure  (aoyogi kouhei <aoyagi.kouhei@gmail.com>)
List pgsql-bugs
"Aoyai Kouhei" <aoyagi.kouhei@gmail.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

pgsql-bugs by date:

Previous
From: "Aoyai Kouhei"
Date:
Subject: BUG #5050: text to timestamp failure
Next
From: "the6campbells"
Date:
Subject: BUG #5051: SQLNumResultCols returns 0 for common table expression