v.20.1New Feature
Add DateTime64 Datatype with Configurable Sub-Second Precision
Add DateTime64 datatype with configurable sub-second precision. #7170 (Vasily Nemkov)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 theDateTime64 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.