Re: Startup parameters timezone conversion - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: Startup parameters timezone conversion
Date
Msg-id 22f1218b-d700-141c-e9ef-08f7cb066411@gmx.net
Whole thread Raw
In response to Re: Startup parameters timezone conversion  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: Startup parameters timezone conversion  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Startup parameters timezone conversion  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-jdbc
Could this be related to Posix time zones?

https://www.postgresql.org/docs/current/datetime-posix-timezone-specs.html

> the positive sign is used for zones west of Greenwich. (Note that this is the opposite of the ISO-8601 sign
conventionused elsewhere in PostgreSQL 

Thomas

Dave Cramer schrieb am 19.01.2022 um 15:01:
> I have to admit to being unable to explain this as well.
>
>
> Dave Cramer
> www.postgres.rocks
>
>
> On Wed, 19 Jan 2022 at 08:22, Leonid Vygovskiy <Leonid.Vygovskiy@gmail.com <mailto:Leonid.Vygovskiy@gmail.com>>
wrote:
>
>     Hi all!
>
>     I study how to work with the timezone in JDBC driver and found the code which I don't understand.
>     This is implementation of the method ConnectionFactoryImpl.createPostgresTimeZone() which has the comment:"
ConvertJava time zone to postgres time zone. All others stay the same except that GMT+n  changes to GMT-nn and vise
versa."
>
>     I'm confused with that changing. Can anybody talk about the reasons and motives of this behavior?
>
>     BR, Leonid Vygovskiy
>



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Startup parameters timezone conversion
Next
From: "David G. Johnston"
Date:
Subject: Re: Startup parameters timezone conversion