Re: Bug in date/time input format - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in date/time input format
Date
Msg-id 17458.1034139997@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in date/time input format  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Peter Eisentraut <peter_e@gmx.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

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Bug #794: JDBC 7.3 PreparedStatement.setNull(..)
Next
From: Ruslan A Dautkhanov
Date:
Subject: Postmaster crash!