Using FROM_UNIXTIME : FROM_UNIXTIME « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. FROM_UNIXTIME

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>








Related examples in the same category

1.FROM_UNIXTIME/UNIX_TIMESTAMP: transformations between MySQL dates (DATE, DATETIME, and TIMESTAMP) and Unix tim
2.To preserve accuracy with DATETIME or TIMESTAMP values, use UNIX_TIMESTAMP( ) and FROM_UNIXTIME( ) instead.