Range of Date and DateTime Types Extended to 2105

Why it matters

This feature was created to overcome the previous limitation on the upper range of Date and DateTime types, which restricted data handling to years before 2105. Extending the range allows users to store, query, and manipulate dates and times well into the future, enhancing the ability to work with long-term temporal data and future-dated records.

How to use it

The extended range is applied automatically to the existing Date and DateTime data types. Users can now insert, query, and work with dates and times up to the year 2105 without any changes to syntax. For example, you can insert a date like '2100-12-31' in a Date column or a timestamp within 2105 in a DateTime column directly.