v.22.3Improvement

Added best_effort_us date time input format

Added date_time_input_format = 'best_effort_us'. Closes #34799. #34982 (WenYao).
Added a new input date and time format option date_time_input_format = 'best_effort_us' to improve parsing of US-style date and time strings.

Why it matters

This feature addresses issues with interpreting various US date and time formats by providing a more flexible and robust parsing mode. It helps users to ingest and process date/time data in non-standard or ambiguous US formats more reliably.

How to use it

Set the parameter date_time_input_format = 'best_effort_us' in your session settings or query context to enable this input format parsing mode.