Postgres Pro
Downloads
Home   >   mailing lists

Re: Inconsistent 'at time zone' conversion - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Inconsistent 'at time zone' conversion
Date
Msg-id 3449861.1676850587@sss.pgh.pa.us
Whole thread Raw
In response to Inconsistent 'at time zone' conversion  (Umut TEKİN <umuttechin@gmail.com>)
Responses Re: Inconsistent 'at time zone' conversion
List pgsql-bugs
Tree view 
=?UTF-8?Q?Umut_TEK=C4=B0N?= <umuttechin@gmail.com> writes:
> I think I found a bug about time zones.

You're just confused about the signs of timezone offsets.
"UTC-7" is read as POSIX notation so that it means 7 hours
east of Greenwich, not west where Denver is.  See

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

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Inconsistent 'at time zone' conversion
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Create user mapping without password