| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Umut TEKİN <umuttechin(at)gmail(dot)com> |
| Cc: | david(dot)g(dot)johnston(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Inconsistent 'at time zone' conversion |
| Date: | 2023-02-20 15:05:49 |
| Message-ID: | 3566454.1676905549@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
=?UTF-8?Q?Umut_TEK=C4=B0N?= <umuttechin(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles | 2023-02-20 15:55:52 | Query run in 27s with 15.2 vs 37ms with 14.6 |
| Previous Message | Umut TEKİN | 2023-02-20 12:54:15 | Re: Inconsistent 'at time zone' conversion |