From: Tom Lane <tgl@sss.pgh.pa.us>
To: Umut TEKİN <umuttechin@gmail.com>
Cc: david.g.johnston@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Inconsistent 'at time zone' conversion
Date: Mon, 20 Feb 2023 10:05:49 -0500
Message-ID: <3566454.1676905549@sss.pgh.pa.us> (raw)
In-Reply-To: <CAPZcZRmMRcCRGCshrqtxJkn4vyuGpLDH0=iWrM0fkc_shBEC0g@mail.gmail.com>
References: <CAPZcZRmcTnGPABC8o+5hwLz2wN0uHK=hG+Xj=swVvDS8i5Dekg@mail.gmail.com>
<3449861.1676850587@sss.pgh.pa.us>
<CAPZcZRmMRcCRGCshrqtxJkn4vyuGpLDH0=iWrM0fkc_shBEC0g@mail.gmail.com>
=?UTF-8?Q?Umut_TEK=C4=B0N?= <umuttechin@gmail.com> writes:
> So, it should be related to the date. Yet, as you can see '2004-10-19
> 10:23:54+03' is nearly the same time of the year 18 years and 4 months ago.
> So, the same DST rules should apply, but it does not.
It's folly to make such an assertion without having checked tzdb ;-).
DST laws change from time to time.
A bit of experimentation shows that Postgres does think both those
zones were observing DST on 2004-10-19, and I would be quite surprised
if it's wrong about that. (Even if it's wrong, that would be tzdb's
bug not ours.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, umuttechin@gmail.com, david.g.johnston@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Inconsistent 'at time zone' conversion
In-Reply-To: <3566454.1676905549@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox