Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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>