Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT FROM_UNIXTIME(1111885200)

mysql> mysql> SELECT FROM_UNIXTIME(1111885200); +---------------------------+ | FROM_UNIXTIME(1111885200) | +---------------------------+ | 2005-03-26 18:00:00       | +---------------------------+ 1 row in set (0.00 sec) mysql>