v.1.1.54362New Feature

Added Functions for Flexible DateTime Parsing

Official CH changelog text
Added the parseDateTimeBestEffort, parseDateTimeBestEffortOrZero, and parseDateTimeBestEffortOrNull functions to read the DateTime from a string containing text in a wide variety of possible formats.
Added the parseDateTimeBestEffort, parseDateTimeBestEffortOrZero, and parseDateTimeBestEffortOrNull functions to parse DateTime values from strings in various formats.

Why it matters

These functions enable users to easily convert strings containing DateTime information in diverse and non-standard formats into ClickHouse DateTime type, improving flexibility and robustness in data ingestion and processing.

How to use it

Use the new functions parseDateTimeBestEffort, parseDateTimeBestEffortOrZero, or parseDateTimeBestEffortOrNull in your queries to convert strings to DateTime. For example: SELECT parseDateTimeBestEffort('2024-06-01 12:34:56').
PreviousNext