Hacker News new | ask | show | jobs
by bashy 1242 days ago
Timestamps in MySQL are 32-bit. It's default in a lot of web frameworks etc.
1 comments
noduerme 1242 days ago
mysql 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-functi...

link
bashy 1241 days ago
That'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

link