v.22.10Improvement
Add Date32 Support to date_diff Function and Fix Unix Epoch Issues
Add a possibility to use Date32 arguments for date_diff function. Fix issue in date_diff function when using DateTime64 arguments with a start date before Unix epoch and end date after Unix epoch. #42308 (Roman Vasin).Why it matters
This feature addresses the limitation of thedate_diff function by allowing it to work correctly with Date32 typed arguments and resolves incorrect calculations when DateTime64 arguments include dates both before and after the Unix epoch, improving accuracy and usability for date difference calculations.How to use it
Use thedate_diff function as usual with Date32 or DateTime64 typed arguments. No special enabling is required; the function now properly supports these types and handles edge cases around the Unix epoch transparently.