Re: ResultSet.getTimestamp(Calendar) off by one-hour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roland Roberts <roland(at)astrofoto(dot)org>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSet.getTimestamp(Calendar) off by one-hour
Date: 2009-03-13 21:50:10
Message-ID: 18696.1236981010@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Roland Roberts <roland(at)astrofoto(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message bsilva 2009-03-13 23:19:31 Postgres transaction error
Previous Message Roland Roberts 2009-03-13 20:46:58 Re: ResultSet.getTimestamp(Calendar) off by one-hour