Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Cramer
Subject Re: Startup parameters timezone conversion
Date
Msg-id CADK3HHKBw527C_C0wcRVhVE7OB6Xi1H3-XWgTCFXD3sqa9Rhnw@mail.gmail.com
Whole thread Raw
In response to Re: Startup parameters timezone conversion  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-jdbc
Tree view

On Wed, 19 Jan 2022 at 09:42, Thomas Kellerer <shammat@gmx.net> wrote:
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

Yes this is the case

test=# set timezone to 'GMT-5';
SET
test=# select now();
              now
-------------------------------
 2022-01-19 20:05:25.515391+05
(1 row)

test=# set timezone to 'GMT+5';
SET
test=# select now();
              now
-------------------------------
 2022-01-19 10:05:52.054867-05
(1 row)


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Startup parameters timezone conversion
Next
From: Dave Cramer
Date:
Subject: Re: Startup parameters timezone conversion