v.20.8New Feature

Add time_zones table

Add time_zones table. #13880 (Bharat Nallan).
Introduces the time_zones system table in ClickHouse.

Why it matters

This feature provides users with a built-in table containing information about time zones, improving the ease of querying and handling time zone data within ClickHouse without relying on external sources.

How to use it

Users can query the system.time_zones table directly to retrieve time zone information using standard SQL, for example: SELECT * FROM system.time_zones.