SELECT FROM_UNIXTIME(1111885200); : FROM_UNIXTIME « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. FROM_UNIXTIME

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

mysql>