v.25.8Improvement

Users can now use Time and Time64

Users can now use Time and Time64 types inside the JSON type. #83784 (Yarik Briukhovetskyi).
Users can now store and work with Time and Time64 data types inside columns of the JSON data type in ClickHouse.

Why it matters

This feature enables handling of time-related data within JSON columns, solving the limitation where Time and Time64 types were previously unsupported inside JSON. It allows more precise and practical time data representation and querying within JSON structures.

How to use it

Simply define a JSON column and insert or query data that contains Time or Time64 values. The ClickHouse engine will now correctly parse and handle these time types inside JSON columns.