v.21.11Improvements

Allow Date Parsing in YYYYMMDD Format

Official CH changelog text
Allow to parse values of Date data type in text formats as YYYYMMDD in addition to YYYY-MM-DD. This closes #30870. #30871 (alexey-milovidov).
ClickHouse now supports parsing Date values in text formats as YYYYMMDD in addition to the existing YYYY-MM-DD format.

Why it matters

This feature enhances date parsing flexibility by allowing users to input dates without delimiters, solving issues when dates are provided in compact numeric formats. It simplifies data ingestion workflows by supporting a common alternative date format.

How to use it

Users can simply provide Date data in the YYYYMMDD format in text inputs or files. ClickHouse will automatically recognize and parse these values as valid dates without additional configuration.

Related resources

PreviousNext