| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Thomas Kellerer <shammat(at)gmx(dot)net> |
| Cc: | "pgsql-jdbc(at)lists(dot)postgresql(dot)org" <pgsql-jdbc(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Startup parameters timezone conversion |
| Date: | 2022-01-19 14:53:17 |
| Message-ID: | CAKFQuwbhzmgRoEJwPzKPkzx_qtJkHAPZs3sAtWekaw3gkCk13g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Wednesday, January 19, 2022, 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
>
Indeed I presume it is. I wonder whether a carefully chosen timezone
specification on the server would cause this to break since the server can
be made to report the offset using either convention and so at least for
some timezone specifications the flipping of the sign would not be required…
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-01-19 14:54:12 | Re: Startup parameters timezone conversion |
| Previous Message | Thomas Kellerer | 2022-01-19 14:41:55 | Re: Startup parameters timezone conversion |