Message-ID: <gh-pgjdbc-pgjdbc-2311-c952876786@github.com>
From: "bokken (@bokken)" <noreply+bokken@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 27 Oct 2021 12:30:15 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #2311: Why is client time zone not configurable?
In-Reply-To: <gh-pgjdbc-pgjdbc-2311@github.com>
References: <gh-pgjdbc-pgjdbc-2311@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: bokken
X-GitHub-Comment-Id: 952876786
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 2311
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/2311#issuecomment-952876786
Content-Type: text/plain; charset=utf-8

If you are not using timestamptz, then use the [ResultSet getTimestamp](https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSet.html#getTimestamp(int,java.util.Calendar)) which takes a `Calendar`. Set the time zone on the calendar to use for interpreting the timestamp.

As @davecramer hinted at, this is all /much/ better if you use timestamptz as the data type.