My current project is a forecasting application with dates going out to 2638 max at the moment. That's not a problem with the max date value for the MariaDB date type 9999-12-31, but it's a quarter of the way there.

I recently had an issue that brought me here - I was trying to pass a value from a Java LocalDate with the value LocalDate.MAX (+999999999-12-31).

I can imagine other users, e.g. astrophysicists, mathematicians, geologists, historians etc would need dates outside the 1000 - 9999 range.

Is there anything in the pipeline?

Is there an idiom for roll-your-own date types that store the year in an unsigned long, and the month and day in tiny ints, or similar?