v.20.1New Feature

Add DateTime64 Datatype with Configurable Sub-Second Precision

Add DateTime64 datatype with configurable sub-second precision. #7170 (Vasily Nemkov)
Added DateTime64 datatype to ClickHouse, supporting configurable sub-second precision for timestamp values.

Why it matters

This feature addresses the need for higher precision time storage beyond seconds, allowing users to store and manipulate timestamps with sub-second resolution, which is valuable for more accurate event tracking and time-based analysis.

How to use it

Use the DateTime64 datatype when creating table columns, specifying the desired precision as a parameter, for example: DateTime64(3) for millisecond precision. This enables storage and querying of timestamps with sub-second granularity.