v.23.10Improvement

Introduced date_time_overflow_behavior setting for handling date conversions

Introduced setting date_time_overflow_behavior with possible values ignore, throw, saturate that controls the overflow behavior when converting from Date, Date32, DateTime64, Integer or Float to Date, Date32, DateTime or DateTime64. #55696 (Andrey Zvonov).
Introduced the setting date_time_overflow_behavior to control overflow handling when converting between date and time data types.

Why it matters

This feature addresses the problem of overflow errors during conversions from Date, 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 setting date_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.