# Can we extend timestamp range to 2160 as mariadb did?

**URL:** <https://forums.percona.com/t/can-we-extend-timestamp-range-to-2160-as-mariadb-did/38120>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, percona\
**Created:** [May 28, 2025, 3:22am UTC](https://forums.percona.com/t/can-we-extend-timestamp-range-to-2160-as-mariadb-did/38120 "2025-05-28T03:22:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shiwei](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@shiwei](https://forums.percona.com/u/shiwei)\
**Post date:** [May 28, 2025, 3:22am UTC](https://forums.percona.com/t/can-we-extend-timestamp-range-to-2160-as-mariadb-did/38120/1 "2025-05-28T03:22:12Z")

</div>

MariaDB has extended timestamp range to ‘2106-02-07 06:28:15 UTC’ from MariaDB 11.5. ([https://jira.mariadb.org/browse/MDEV-32188](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 😃

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 28, 2025, 3:05pm UTC](https://forums.percona.com/t/can-we-extend-timestamp-range-to-2160-as-mariadb-did/38120/2 "2025-05-28T15:05:12Z")

</div>

Hello @shiwei,  
Please open this feature request for `TIMESTAMP` column at [https://jira.percona.com/](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:

> - [`DATE`](https://dev.mysql.com/doc/refman/8.4/en/datetime.html)A date. The supported range is `'1000-01-01'` to `'9999-12-31'`. MySQL displays [`DATE`](https://dev.mysql.com/doc/refman/8.4/en/datetime.html) values in `'YYYY-MM-DD`’ format, but permits assignment of values to [`DATE`](https://dev.mysql.com/doc/refman/8.4/en/datetime.html) columns using either strings or numbers.

> [`DATETIME[(fsp`)]]([https://dev.mysql.com/doc/refman/8.4/en/datetime.html](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'`