v.20.5Improvement
Return NULL/zero for incomplete parsing in parseDateTimeBestEffortOrNull/Zero functions
Return NULL/zero when value is not parsed completely in parseDateTimeBestEffortOrNull/Zero functions. This fixes #7876. #11653 (alexey-milovidov).
Why it matters
This feature fixes an issue where these functions could return incorrect or partially parsed results when the input date-time string was not fully parsed. By returningNULL or zero instead, the functions now provide more reliable and predictable outputs, preventing errors or misleading data due to incomplete parsing.How to use it
Simply use the<code>parseDateTimeBestEffortOrNull</code> or <code>parseDateTimeBestEffortOrZero</code> functions as usual in your queries. When the input cannot be fully parsed into a valid date-time, the functions will return NULL or zero respectively instead of incorrect partial values.