Re: date/time out of range

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Samuel Gendler <sgendler(at)ideasculptor(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 06:01:39
Message-ID: 4D352CC3.1060004@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2011-01-18 16:10:22 Re: date/time out of range
Previous Message Samuel Gendler 2011-01-18 05:29:59 Re: date/time out of range