date/time out of range

From: Colin Taylor <colin(dot)taylor(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: date/time out of range
Date: 2011-01-18 04:00:06
Message-ID: AANLkTi=zUztkJbc_N9aoQdS0eOwJWCCta79jNO3WCuAu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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"

The date appears to be valid,

smx3_mailreport=# select timestamp '2011-01-12 21:30:00.000000 +13:00:00';
timestamp
---------------------
2011-01-12 21:30:00
(1 row)

I cant see how any session paramater would affect this?

OSX - Postgres 8.4.4 , jdbc 8.4.702

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-01-18 04:20:03 Re: date/time out of range
Previous Message Samuel Gendler 2011-01-17 23:28:47 Re: ERROR: transaction is read-only