v.25.5Improvement

Support unix timestapms with fractional part

Support unix timestapms with fractional part in best effort DateTime64 parsing. #78908 (Pavel Kruglov).
Added support for parsing Unix timestamps with fractional seconds in DateTime64 format in a best-effort manner.

Why it matters

This feature addresses the limitation of parsing Unix timestamps by enabling the DateTime64 parser to handle timestamps that include fractional parts, improving precision and flexibility when working with time data containing sub-second information.

How to use it

Users can now input Unix timestamps with fractional seconds directly into DateTime64 columns or functions, and ClickHouse will parse these values correctly without additional configuration.