Re: Bug in date/time input format

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Christopher Swan <chris(at)exile(dot)co(dot)nz>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in date/time input format
Date: 2002-10-09 05:06:37
Message-ID: 17458.1034139997@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Christopher Swan writes:
>> If I use the following format:
>> 'Tue, 08 Oct 2002 10:01:02 +1300'
>> then I get the following error:

> Is there a spot in the documentation that leads you to believe that this
> format is supported? If not, then it's not a bug.

It is a bug, because +1300 *should* be accepted. The fact that you
can't get more than 180 degrees of longitude away from Greenwich has
not deterred the politicians who set timezone rules :-(. I don't know
of any -1300 time zone, but +1300 is used in the real world.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ruslan A Dautkhanov 2002-10-09 06:01:48 Postmaster crash!
Previous Message Kris Jurka 2002-10-08 22:34:52 Re: Bug #794: JDBC 7.3 PreparedStatement.setNull(..)