FROM_UNIXTIME « Date Time « SQL / MySQL






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