v.22.2Improvement

Recognize YYYYMMDD-hhmmss Format in parseDateTimeBestEffort Function

Recognize YYYYMMDD-hhmmss format in parseDateTimeBestEffort function. This closes #34206. #34208 (alexey-milovidov).
The parseDateTimeBestEffort function now recognizes date-time strings in the YYYYMMDD-hhmmss format.

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 as YYYYMMDD-hhmmss, simplifying ingestion and processing.

How to use it

Users can simply pass date-time strings in the YYYYMMDD-hhmmss format to the parseDateTimeBestEffort function, which will automatically recognize and correctly parse them without requiring any additional configuration.