v.22.2Improvement
Recognize YYYYMMDD-hhmmss Format in parseDateTimeBestEffort Function
RecognizeYYYYMMDD-hhmmssformat inparseDateTimeBestEffortfunction. This closes #34206. #34208 (alexey-milovidov).
Why it matters
This feature improves the flexibility and robustness of date-time parsing in ClickHouse by supporting an additional commonly used compact date-time format. It helps users avoid manual data transformation steps when working with timestamps formatted asYYYYMMDD-hhmmss, simplifying ingestion and processing.How to use it
Users can simply pass date-time strings in theYYYYMMDD-hhmmss format to the parseDateTimeBestEffort function, which will automatically recognize and correctly parse them without requiring any additional configuration.