mysql> select FROM_UNIXTIME(1234567890); +---------------------------+ | FROM_UNIXTIME(1234567890) | +---------------------------+ | 2009-02-14 02:31:30 | +---------------------------+ 1 row in set (0.00 sec)