mysql 8.0.28 on 64-bit platforms support timestamps up to the year 3001, if I'm ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		noduerme on Jan 24, 2023 \| parent \| context \| favorite \| on: Setting the clock ahead to see what breaks 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...

bashy on Jan 24, 2023 [–]

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

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact