v.22.8Backward Incompatible Changes
Extended Date Range Support for Date32 and DateTime64 (1900-2299)
Extended range ofDate32andDateTime64to support dates from the year 1900 to 2299. In previous versions, the supported interval was only from the year 1925 to 2283. The implementation is using the proleptic Gregorian calendar (which is conformant with ISO 8601:2004 (clause 3.2.1 The Gregorian calendar)) instead of accounting for historical transitions from the Julian to the Gregorian calendar. This change affects implementation-specific behavior for out-of-range arguments. E.g. if in previous versions the value of1899-01-01was clamped to1925-01-01, in the new version it will be clamped to1900-01-01. It changes the behavior of rounding withtoStartOfIntervalif you passINTERVAL 3 QUARTERup to one quarter because the intervals are counted from an implementation-specific point of time. Closes #28216, improves #38393. #39425 (Roman Vasin).