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
FunctionparseDateTimeBestEffort: support for formatsDD.MM.YYYY,DD.MM.YY,DD-MM-YYYY,DD-Mon-YYYY,DD/Month/YYYYand similar. #3922 (alexey-milovidov)
Why it matters
This feature expands the flexibility ofparseDateTimeBestEffort 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 theparseDateTimeBestEffort function in their SQL queries to parse date-time strings in the newly supported formats. No additional configuration is needed.