Horton

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

ocean_li_996 <ocean_li_996@163.com>

View thread
From: ocean_li_996 <ocean_li_996@163.com>
To: "jbe-mlist@magnetkern.de " <jbe-mlist@magnetkern.de>, "pgsql-bugs@lists.postgresql.org " <pgsql-bugs@lists.postgresql.org>
Date: 2025-09-15T16:03:42Z
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