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

@jorsol, @davecramer sry im kinda super busy these days, so the answers were short and most probably lacking info :) sry for that!

the problem is:
* DB not running in UTC(not configurable)
* jvm not running in UTC(lets say not configurable)

timestamp(z)s are converted to local timestamps, since the app kinda doesnt care about any timezones(it passes them simply forward), the session timezone would actually be correct. Now heres the kicker, its impossible to change that except changing the whole jvm, which is super inconvenient for all devs (since devs usually dont have their local machines in UTC). 

so either an optional flag (to mitigate possible timezone issues) to use server timezone or JVM timezone, or a flag to set the session timezone could come in handy here