Re: date/time out of range

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@opencloud.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"
>>
>> You should show us the code that generates this error, and your schema.
>>
>> Oliver
>>
>
> select id, name, address_type_id, default_timezone, customer_ref,
> from_date from domain where
> (from_date<= '2011-01-12 21:30:00.000000 +13:00:00' or from_date is
> null) and (thru_date is null or
> thru_date>  '2011-01-12 21:30:00.000000 +13:00:00')   and
> address_type_id = '10' and name in ('ALL','<>');

Well.. that's not JDBC code, is it? If I run that in psql against 8.4.5,
it runs just fine and I see no error. How do you actually construct and
execute that query via JDBC?

We need a selfcontained test case that compiles and runs "out of the
box" showing the problem. Otherwise I don't think anyone can help you here.

Oliver