Re:BUG #19053: Inconsistent arithmetic regarding TIMESTAMPTZ and INTERVAL

From: ocean_li_996 <ocean_li_996(at)163(dot)com>
To: "jbe-mlist(at)magnetkern(dot)de " <jbe-mlist(at)magnetkern(dot)de>, "pgsql-bugs(at)lists(dot)postgresql(dot)org " <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re:BUG #19053: Inconsistent arithmetic regarding TIMESTAMPTZ and INTERVAL
Date: 2025-09-15 16:03:42
Message-ID: 2601954f.8be.1994e1e24b2.Coremail.ocean_li_996@163.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,
I think this is caused by the daylight saving time and standard time changes in the Europe/Berlin timezone.
It is not a bug, but the expected behavior. In 2025, daylight saving time starts at '2025-03-30 01:00 UTC'
and ends at '2025-10-26 01:00 UTC'. When changing, it will make one hour gap.

--

regards
Haiyang Li

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-09-15 16:15:26 Re: BUG #18959: Name collisions of expression indexes during parallel Index creations on a pratitioned table.
Previous Message Tom Lane 2025-09-15 15:41:29 Re: BUG #19053: Inconsistent arithmetic regarding TIMESTAMPTZ and INTERVAL