FROM_UNIXTIME()
Function Description
The FROM_UNIXTIME() function converts the internal UNIX timestamp value to a date and time value in normal format and displays it in YYYY-MM-DD HH:MM:SS or YYYMMDDHHMMSS format. It is inverse to the UNIX_TIMESTAMP () function.
Function Syntax
> FROM_UNIXTIME(unix_timestamp[,format])
Parameter definition
| Parameters | Description |
|---|---|
| format | Optional parameters. A format string representing the format of the return value. If format is omitted, a DATETIME value is returned. If format is empty, return NULL. format is used to format the results in the same way as the format string used by the DATE_FORMAT() function. If format already has the specified format, the return value is VARCHAR. |
| unix_timestamp | Required parameters. Time stamp, a field in the database that stores time data. If unix_timestamp is empty, NULL is returned. If unix_timestamp is an integer, the fractional-second accuracy of DATETIME is zero. When unix_timestamp is a decimal value, the decimal second accuracy of DATETIME is the same as the decimal value, up to 6 seconds. When unix_timestamp is a floating point number, the minute-second accuracy of datetime is 6. |
Example
mysql> SELECT FROM_UNIXTIME(1447430881);
+--------------------------------+
| from_unixtime(1447430881) |
+--------------------------------+
| 2015-11-14 00:08:01 |
+--------------------------------+
1 row in set (0.00 sec)
mysql> SELECT FROM_UNIXTIME(1447430881, '%Y %D %M %h:%i:%s %x');
+------------------------------------------------------------------+
| from_unixtime(1447430881, %Y %D %M %h:%i:%s %x) |
+------------------------------------------------------------------+
| 2015 14th November 12:08:01 2015 |
+------------------------------------------------------------------+
1 row in set (0.00 sec)
limit
Currently, the date format only supports the data formats of yyyy-mm-dd and yyyymmdd.