v.24.10Improvement

Support DateTime64 Parsing with Microseconds and Timezone in Joda Syntax

Support parsing DateTime64 for microsecond and timezone in joda syntax ("joda" is a popular Java library for date and time, and the "joda syntax" is that library's style). #70737 (kevinyhzou).
Support parsing DateTime64 values using microsecond precision and timezone information with the Joda time syntax.

Why it matters

This feature enables users to parse DateTime64 data types more flexibly by allowing microsecond precision and timezone offsets in the Joda syntax format. It addresses limitations in date/time parsing and improves compatibility with systems and formats using Joda time patterns.

How to use it

Users can specify the Joda syntax pattern when parsing DateTime64 data to include microsecond precision and timezone info. This feature is applied automatically when the Joda format is used for DateTime64 columns or conversions.