Message-ID: <gh-pgjdbc-pgjdbc-2311-c952903604@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 27 Oct 2021 13:01:24 +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: davecramer
X-GitHub-Comment-Id: 952903604
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-952903604
Content-Type: text/plain; charset=utf-8

Well setting the timezone for the string will have 0 effect on Timestamps without timezones. The server will not change the timezone for those.

```
create table foo (ts timestamp, tz timestamptz);
CREATE TABLE
postgres=# insert into foo values (now(),now());
INSERT 0 1
postgres=# select * from foo;
             ts             |              tz
----------------------------+-------------------------------
 2021-10-27 08:59:21.824902 | 2021-10-27 08:59:21.824902-04
(1 row)

postgres=# set timezone to -5;
SET
postgres=# select * from foo;
             ts             |              tz
----------------------------+-------------------------------
 2021-10-27 08:59:21.824902 | 2021-10-27 07:59:21.824902-05
```

As you can see only the timestamp with time zone changes when I change the session timezone.

I fail to see how setting the session timezone fixes anything for you.

As for your other problem that would be something to discuss with hackers