v.22.9Improvement

Allow Date Parsing as DateTime and DateTime64

Official CH changelog text
Allow parsing Date as DateTime and DateTime64. This implements the enhancement proposed in #36949. #40474 (Alexey Milovidov).
Allows parsing Date values as DateTime and DateTime64 types in ClickHouse, enabling seamless conversion and compatibility between these data types.

Why it matters

This feature addresses the need to easily convert or interpret Date type data as DateTime or DateTime64, simplifying data handling and reducing errors when working with mixed date and datetime formats. It improves flexibility for users dealing with time-based data by extending parsing capabilities.

How to use it

Users can now directly parse columns or literals of Date type as DateTime or DateTime64 without additional casting or conversion steps. This behavior is enabled by default after upgrading to the version with this feature.

Related resources

PreviousNext