v.21.4New Features
Extended DateTime64 Range Support and Improved DateTime Functions
Extended range ofDateTime64to support dates from year 1925 to 2283. Improved support ofDateTimearound zero date (1970-01-01). #9404 (alexey-milovidov, Vasily Nemkov). Not every time and date functions are working for extended range of dates.
Why it matters
This feature addresses the limitation of the previousDateTime64 and DateTime types by expanding the valid date range, allowing users to work with a wider span of historical and future dates. It improves date-time processing accuracy and usability around the epoch date for diverse application needs.How to use it
Users can take advantage of the extended date range by continuing to use theDateTime64 and DateTime data types as usual. No additional configuration is required, but users should be aware that not all time and date functions may fully support the new extended range.