MySQL’s built in FROM_UNIXTIME() function only handles positive numbers however we can still convert negative integers to dates using its handy DATE_ADD() function like so:
1 | SELECT DATE_ADD(FROM_UNIXTIME(0), INTERVAL -13391999 SECOND) |
which gives:
1 | 1969-07-30 10:00:01 |
Note that this also works with positive numbers, so if your database contains a mixture of both it’s still safe to use.
Credit to user fat_kid for his tutorial here.