v.20.6New Feature

Added parseDateTimeBestEffortUS Function

Added function parseDateTimeBestEffortUS. #12028 (flynn).
Added the function parseDateTimeBestEffortUS to ClickHouse.

Why it matters

This function provides an enhanced way to parse datetime strings that are formatted in US-style date formats. It solves the problem of handling various US datetime string representations flexibly and accurately, ensuring better compatibility and ease of use when working with dates in US formats.

How to use it

Use the function in your SQL queries by calling parseDateTimeBestEffortUS with a datetime string as its argument, for example:

SELECT parseDateTimeBestEffortUS('03/25/2024 14:30:00')