aoyogi kouhei writes:
>> You did not say what timezone setting you are using, but in some of them
>> this is not wrong.
> My timezone is Asia/Tokyo. utc_offset_interval is 09:00:00.
According to the Olson timezone database, Tokyo observed local mean
solar time until the end of 1887:
--- snip --
Thanks reply.
My timezone is Asia/Tokyo. utc_offset_interval is 09:00:00.
2009/9/13 Tom Lane
> "Aoyai Kouhei" 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:5
"Aoyai Kouhei" 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.
The following bug has been logged online:
Bug reference: 5050
Logged by: Aoyai Kouhei
Email address: aoyagi.kou...@gmail.com
PostgreSQL version: 8.4.1
Operating system: MacOS 10.6.1
Description:text to timestamp failure
Details:
select '0001-01-01'::timestamp with t
