v.1.1.54310New Feature

Added Support for Non-Integer UTC Time Zone Offsets

Added support for time zones with non-integer offsets from UTC.
Added support for time zones with non-integer offsets from UTC in ClickHouse.

Why it matters

This feature was created to enable ClickHouse to properly handle and process time zone offsets that are not whole hours, such as UTC+5:30 or UTC+9:45. This improves temporal data accuracy and compatibility for users working with regions that use fractional UTC offsets.

How to use it

Specify time zones with non-integer UTC offsets in queries or server settings as usual. ClickHouse will now correctly interpret and apply these offsets in datetime operations, enabling accurate time zone conversions and comparisons.