Hacker News Reader

Timestamps in MySQL are 32-bit. It's default in a lot of web frameworks etc.

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...

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

Reply on news.ycombinator.com