Postgres Pro
Downloads
Home   >   mailing lists

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

From Samuel Gendler
Subject Re: date/time out of range
Date
Msg-id AANLkTin4Q5efXgRoY9AVRFFwgYOcGTOZr8e6tTtdZ+sZ@mail.gmail.com
Whole thread Raw
In response to Re: date/time out of range  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: date/time out of range
Re: date/time out of range
List pgsql-jdbc
Tree view
On Mon, Jan 17, 2011 at 9:15 PM, Oliver Jowett <oliver@opencloud.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@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"


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.


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: date/time out of range
Next
From: Oliver Jowett
Date:
Subject: Re: date/time out of range