v.19.1Improvements

Function Parsedatetimebesteffort: Support for Formats Dd.mm.yyyy, Dd.mm.yy, Dd-mm-yyyy, Dd-mon-yyyy, Dd/month/yyyy and Similar

Function parseDateTimeBestEffort: support for formats DD.MM.YYYY, DD.MM.YY, DD-MM-YYYY, DD-Mon-YYYY, DD/Month/YYYY and similar. #3922 (alexey-milovidov)
Added support in the function parseDateTimeBestEffort for additional date formats including DD.MM.YYYY, DD.MM.YY, DD-MM-YYYY, DD-Mon-YYYY, DD/Month/YYYY and similar variations.

Why it matters

This feature expands the flexibility of parseDateTimeBestEffort to correctly parse a wider range of commonly used date formats, making it easier for users to ingest and work with date-time data in diverse formats without manual preprocessing.

How to use it

Users can take advantage of this feature by simply using the parseDateTimeBestEffort function in their SQL queries to parse date-time strings in the newly supported formats. No additional configuration is needed.