Re: Startup parameters timezone conversion

On Wed, 19 Jan 2022 at 09:42, Thomas Kellerer <shammat(at)gmx(dot)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)

>