| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Samuel Gendler <sgendler(at)ideasculptor(dot)com> |
| Cc: | Oliver Jowett <oliver(at)opencloud(dot)com>, Colin Taylor <colin(dot)taylor(at)gmail(dot)com>, pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: date/time out of range |
| Date: | 2011-01-18 16:10:22 |
| Message-ID: | 10987.1295367022@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Samuel Gendler <sgendler(at)ideasculptor(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Quartz | 2011-01-18 17:28:15 | jdbc spec violation for autocommit=true & addbatch/executeBatch |
| Previous Message | Oliver Jowett | 2011-01-18 06:01:39 | Re: date/time out of range |