Re: BUG #5050: text to timestamp failure

From: aoyogi kouhei <aoyagi(dot)kouhei(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5050: text to timestamp failure
Date: 2009-09-13 00:04:04
Message-ID: 391b0e220909121704y4b44fa8i8034eb2da9cdee7a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks reply.
My timezone is Asia/Tokyo. utc_offset_interval is 09:00:00.

2009/9/13 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> "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 Tom Lane 2009-09-13 02:01:28 Re: BUG #5050: text to timestamp failure
Previous Message Joe Conway 2009-09-12 23:22:32 Re: dblink generates orphaned connections