Re: Startup parameters timezone conversion

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Re: Startup parameters timezone conversion
Date: 2022-01-19 14:41:55
Message-ID: 22f1218b-d700-141c-e9ef-08f7cb066411@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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 convention used 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(dot)Vygovskiy(at)gmail(dot)com <mailto:Leonid(dot)Vygovskiy(at)gmail(dot)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:" Convert Java 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
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David G. Johnston 2022-01-19 14:53:17 Re: Startup parameters timezone conversion
Previous Message Dave Cramer 2022-01-19 14:01:05 Re: Startup parameters timezone conversion