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

From Oliver Jowett
Subject Re: date/time out of range
Date
Msg-id 4D352CC3.1060004@opencloud.com
Whole thread Raw
In response to Re: date/time out of range  (Samuel Gendler <sgendler@ideasculptor.com>)
List pgsql-jdbc
Samuel Gendler wrote:

> 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.

+1300 is fine (NZ in summer - I'm there now!)
The Chatham Islands are even further east while still on the same side
of the dateline, they're +1345 at the moment.

Older server versions had problems with timezones beyond +1200, but that
was fixed ages ago (7.x era)

Oliver

pgsql-jdbc by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: date/time out of range
Next
From: Tom Lane
Date:
Subject: Re: date/time out of range