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

From aoyogi kouhei
Subject Re: BUG #5050: text to timestamp failure
Date
Msg-id 391b0e220909121704y4b44fa8i8034eb2da9cdee7a@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5050: text to timestamp failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5050: text to timestamp failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Thanks reply.
My timezone is Asia/Tokyo. utc_offset_interval is 09:00:00.

2009/9/13 Tom Lane <tgl@sss.pgh.pa.us>

> "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: Joe Conway
Date:
Subject: Re: dblink generates orphaned connections
Next
From: Tom Lane
Date:
Subject: Re: BUG #5050: text to timestamp failure