Re: ResultSet.getTimestamp(Calendar) off by one-hour - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: ResultSet.getTimestamp(Calendar) off by one-hour
Date
Msg-id 18696.1236981010@sss.pgh.pa.us
Whole thread Raw
In response to Re: ResultSet.getTimestamp(Calendar) off by one-hour  (Roland Roberts <roland@astrofoto.org>)
List pgsql-jdbc
Roland Roberts <roland@astrofoto.org> writes:
> I can certainly try timestamp with time zone, but the plan is to deploy
> with a column that does not include time zone because all times are
> supposed to be stored in UTC.

Hm, do you have the server's TimeZone setting set to UTC?  Maybe the
JDBC driver is overriding that?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Roland Roberts
Date:
Subject: Re: ResultSet.getTimestamp(Calendar) off by one-hour
Next
From: bsilva
Date:
Subject: Postgres transaction error