3 ms·
Don't use UNIX_TIMESTAMP() or FROM_UNIXTIME(). Both overflow in 2038.
by tyingq 8y ago
Don't use UNIX_TIMESTAMP() or FROM_UNIXTIME(). Both overflow in 2038.
- perlgeek 8y agoI hoped you were kidding me, but no: $ perl -wE 'say scalar localtime 2177449200' Sat Jan 1 00:00:00 2039 > select FROM_UNIXTIME(2177449200); +---------------------------+ | FROM_UNIXTIME(2177449200) | +---------------------------+ | NULL | +---------------------------+ 1 row in set (0.000 sec) I work on a code base where the word UNIX_TIMESTAMP occurs 400 times :(