Re: date/time out of range

Samuel Gendler <sgendler@ideasculptor.com> writes:
>> On 18/01/11 17:00, Colin Taylor wrote:
>>> 10127 Caused by: org.postgresql.util.PSQLException: ERROR: date/time
>>> field value out of range: "2011-01-12 21:30:00.000000 +13:00:00"

> Is there a +13:00:00 timezone or does that wind up crossing the date line?
> If Java has no mechanism for converting that time zone to whatever date/time
> type it is trying to convert to, the exception would make sense.

The weird thing is that the message appears to be a server-side error;
at least it exactly matches the spelling of one server error.  But I
don't understand how come it occurs only from JDBC and not in psql.

            regards, tom lane