Message-ID: <gh-pgjdbc-pgjdbc-2311-c953052691@github.com>
From: "jorsol (@jorsol)" <noreply+jorsol@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 27 Oct 2021 15:38:25 +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: jorsol
X-GitHub-Comment-Id: 953052691
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-953052691
Content-Type: text/plain; charset=utf-8

@riba2101 Is there a particular issue you are facing? Do you have some example code that shows the problem? many people use UTC on the servers and a local timezone on their machines without problems.

In Postgres all timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone specified by the TimeZone configuration parameter before being displayed to the client.  So we need to understand what is the real issue that requires a configurable time zone.