Re: date/time out of range

From: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: 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 05:29:59
Message-ID: AANLkTin4Q5efXgRoY9AVRFFwgYOcGTOZr8e6tTtdZ+sZ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, Jan 17, 2011 at 9:15 PM, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:

> Please remember to cc: the list when you reply.
>
> On 18/01/11 18:01, Colin Taylor wrote:
>
>> On Tue, Jan 18, 2011 at 5:20 PM, Oliver Jowett<oliver(at)opencloud(dot)com>
>> wrote:
>>
>> On 18/01/11 17:00, Colin Taylor wrote:
>>>
>>>>
>>>> This error confuses me:
>>>>
>>>> 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.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-01-18 06:01:39 Re: date/time out of range
Previous Message Oliver Jowett 2011-01-18 05:15:17 Re: date/time out of range