4 ms·
Timestamps in MySQL are 32-bit. It's default in a lot of web frameworks etc.
by bashy 4y ago
Timestamps in MySQL are 32-bit. It's default in a lot of web frameworks etc.
- noduerme 4y agomysql 8.0.28 on 64-bit platforms support timestamps up to the year 3001, if I'm reading it right[1]. But it's still mind-boggling someone would write a database that would crash in 2038. [1] https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functi...
- bashy 4y agoThat's just converting unix timestamps. MySQL TIMESTAMP type only has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.[1] [1] https://dev.mysql.com/doc/refman/8.0/en/datetime.html https://dev.mysql.com/doc/refman/8.0/en/datetime.html