Mega Code Archive
Using FROM_UNIXTIME
mysql>
mysql> SELECT FROM_UNIXTIME(1103600000);
+---------------------------+
| FROM_UNIXTIME(1103600000) |
+---------------------------+
| 2004-12-20 19:33:20 |
+---------------------------+
1 row in set (0.00 sec)
mysql>
mysql>