v.22.11Improvement

Update tzdata: Mexico abolishes DST, Chihuahua adopts year-round UTC-6

Official CH changelog text
Update tzdata to 2022f. Mexico will no longer observe DST except near the US border: https://www.timeanddate.com/news/time/mexico-abolishes-dst-2022.html. Chihuahua moves to year-round UTC-6 on 2022-10-30. Fiji no longer observes DST. See https://github.com/google/cctz/pull/235 and https://bugs.launchpad.net/ubuntu/+source/tzdata/+bug/1995209. #42796 (Alexey Milovidov).
Updated the tzdata to version 2022f, reflecting recent changes in daylight saving time (DST) observance in various regions, including Mexico and Fiji.

Why it matters

This update ensures that ClickHouse uses the latest and most accurate timezone and DST information. Specifically, it accommodates Mexico's abolition of DST except near the US border, Chihuahua's shift to year-round UTC-6 from 2022-10-30, and Fiji's cessation of DST. This improves the correctness of time calculations and conversions for users relying on time zone-aware functions.

How to use it

The update is applied automatically in ClickHouse when upgrading to the version that includes tzdata 2022f. Users benefit from accurate time zone and DST data without requiring additional configuration.

Related resources

PreviousNext