Re: date/time out of range - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: date/time out of range
Date
Msg-id 10987.1295367022@sss.pgh.pa.us
Whole thread Raw
In response to Re: date/time out of range  (Samuel Gendler <sgendler@ideasculptor.com>)
Responses Re: date/time out of range
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: date/time out of range
Next
From: Quartz
Date:
Subject: jdbc spec violation for autocommit=true & addbatch/executeBatch