Can we extend timestamp range to 2160 as mariadb did?

MySQL & MariaDB
,
1

MariaDB has extended timestamp range to ‘2106-02-07 06:28:15 UTC’ from MariaDB 11.5. (https://jira.mariadb.org/browse/MDEV-32188) :

“Currently timestamp is 32-bit signed, although negative values are rejected, so it is de facto 31-bit, allowing values from 1970 to 2038.
We can make it 32-bit unsigned extending timestamp range to 2106, and it won’t require many changes to the storage.”

However, Percona Server still has the 2038 limitation, I wonder if it’s possible to merge this feature from mariadb,thx :smiley:

2

Hello @shiwei,
Please open this feature request for TIMESTAMP column at https://jira.percona.com/ Our engineering, and product teams will evaluate the request to determine how much effort will be required, along with maintaining upstream compatibility with MySQL.

Until then, you can use either DATE or DATETIME column types:

  • DATEA date. The supported range is '1000-01-01' to '9999-12-31'. MySQL displays DATE values in 'YYYY-MM-DD’ format, but permits assignment of values to DATE columns using either strings or numbers.

[DATETIME[(fsp)]](https://dev.mysql.com/doc/refman/8.4/en/datetime.html)

A date and time combination. The supported range is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.499999'