v.25.5Experimental Feature
New Time/Time64 data types: Time (HHH:MM:SS) and
NewTime/Time64data types:Time(HHH:MM:SS) andTime64(HHH:MM:SS.<fractional>) and some basic cast functions and functions to interact with other data types. Also, changed the existing function's name toTime to toTimeWithFixedDate because the function toTime is required for the cast function. #75735 (Yarik Briukhovetskyi). 72459).
Why it matters
This feature provides more precise and flexible time representations supporting hours beyond 24 and fractional seconds, which were not adequately handled before. It enables users to work with extended time intervals and high-precision time data natively in ClickHouse, improving time-related querying and type casting capabilities.How to use it
Use the newTime and Time64 data types when defining table schema or casting values. Cast to Time or Time64 using the newly defined toTime cast function. Note that the previous toTime function has been renamed to toTimeWithFixedDate to avoid naming conflicts.