Message-ID: <gh-pgjdbc-pgjdbc-2311-c2660691848@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Sat, 15 Feb 2025 03:24:22 +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: 2660691848
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-2660691848
Content-Type: text/plain; charset=utf-8

Simple,

So that timestamp with time zone will be returned in your time zone

Dave Cramer


On Fri, Feb 14, 2025 at 10:20 PM Сергей Б. ***@***.***> wrote:

> Could anybody explain why on Earth it is necessary to inform database
> server about client timezone? What is it used for at the server side?
> Imagine that my client has timezone Europe/Kurlandia. When it tries to
> connect to PostgreSQL Server, it gets an error Invalid value for parameter
> "TimeZone": "Europe/Kurlandia". What exactly does the server fail to do,
> when it learns that the client has a timezone which is unknown for server's
> locale libraries?
>
> I do understand how client timezone is used at client side. But I have no
> idea why database server cares what client timezone is.
> Can I just disable those tricky client-timezone-sensitive server features?
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/pgjdbc/pgjdbc/issues/2311#issuecomment-2660690692>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AADDH5TA2NBGI7NAH2GGUAL2P2XBTAVCNFSM6AAAAABVYULISCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNRQGY4TANRZGI>
> .
> You are receiving this because you modified the open/close state.Message
> ID: ***@***.***>
> [image: seregaizsbera]*seregaizsbera* left a comment (pgjdbc/pgjdbc#2311)
> <https://github.com/pgjdbc/pgjdbc/issues/2311#issuecomment-2660690692>
>
> Could anybody explain why on Earth it is necessary to inform database
> server about client timezone? What is it used for at the server side?
> Imagine that my client has timezone Europe/Kurlandia. When it tries to
> connect to PostgreSQL Server, it gets an error Invalid value for parameter
> "TimeZone": "Europe/Kurlandia". What exactly does the server fail to do,
> when it learns that the client has a timezone which is unknown for server's
> locale libraries?
>
> I do understand how client timezone is used at client side. But I have no
> idea why database server cares what client timezone is.
> Can I just disable those tricky client-timezone-sensitive server features?
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/pgjdbc/pgjdbc/issues/2311#issuecomment-2660690692>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AADDH5TA2NBGI7NAH2GGUAL2P2XBTAVCNFSM6AAAAABVYULISCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNRQGY4TANRZGI>
> .
> You are receiving this because you modified the open/close state.Message
> ID: ***@***.***>
>