v.23.4Improvement

parseDateTime now supports '%f' format for fractional seconds

Official CH changelog text
parseDateTime now understands format string '%f' (fractional seconds). #48420 (Robert Schulze).
parseDateTime function now supports the %f format specifier for fractional seconds.

Why it matters

This feature allows users to parse datetime strings that include fractional seconds, improving the precision and flexibility of datetime parsing in ClickHouse.

How to use it

Use the <code>parseDateTime</code> function with a format string that includes %f to parse datetime values containing fractional seconds. For example:

SELECT parseDateTime('2024-06-01 12:30:15.123456', '%Y-%m-%d %H:%M:%S.%f')

Related resources

PreviousNext