v.21.9Improvement

Improve Non-Whole-Minute Timezone Offset Compatibility

Improve compatibility with non-whole-minute timezone offsets. #27080 (Raúl Marín).
Enhance ClickHouse timezone handling to support non-whole-minute timezone offsets accurately.

Why it matters

This feature addresses the limitation of previous timezone implementations that only supported whole-minute offsets. It enables users to work with timezones having offsets with seconds precision, improving the accuracy of datetime operations and compatibility with diverse timezone data.

How to use it

Users do not need to apply any special configuration. The improved timezone offset compatibility is integrated into ClickHouse and works automatically when specifying timezones with non-whole-minute offsets in datetime functions or settings.