v.23.10Improvement
Introduced date_time_overflow_behavior setting for handling date conversions
Introduced settingdate_time_overflow_behaviorwith possible valuesignore,throw,saturatethat controls the overflow behavior when converting from Date, Date32, DateTime64, Integer or Float to Date, Date32, DateTime or DateTime64. #55696 (Andrey Zvonov).
Why it matters
This feature addresses the problem of overflow errors during conversions fromDate, Date32, DateTime64, Integer, or Float types to Date, Date32, DateTime, or DateTime64. It improves stability and flexibility by allowing users to specify how such overflows should be handled, thus preventing unexpected exceptions or data corruption.How to use it
Use the settingdate_time_overflow_behavior with one of the following values: ignore (to silently ignore overflow), throw (to raise an exception on overflow), or saturate (to clamp the value to the nearest valid limit). Set this parameter in your session or query settings to control overflow behavior during date/time conversions.