v.22.3Improvement
Added best_effort_us date time input format
Added date_time_input_format = 'best_effort_us'. Closes #34799. #34982 (WenYao).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 parameterdate_time_input_format = 'best_effort_us' in your session settings or query context to enable this input format parsing mode.