Description
The FROM_UNIXTIME( ) function returns a unix_timestamp representation in the format 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu
This function has the form:
SELECT FROM_UNIXTIME(unix_timestamp)
Parameter | Description |
---|---|
unix_timestamp | An internal timestamp value |
Return Value
Returns a unix_timestamp representation in the format 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu
Examples
The following example shows the basic use of this function:
mysql> SELECT FROM_UNIXTIME(1196440219);
-> '2007-11-30 10:30:19'
mysql> SELECT FROM_UNIXTIME(1196440219) + 0;
-> 20071130103019.000000
mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),
-> '%Y %D %M %h:%i:%s %x');
-> '2007 30th November 10:30:59 2007'