使用 MySQL 将 Unix 时间戳转换为人类可读的日期

Is there a MySQL function which can be used to convert a Unix timestamp into a human readable date? I have one field where I save Unix times and now I want to add another field for human readable dates.

推荐答案

使用 FROM_UNIXTIME():

SELECT
  FROM_UNIXTIME(timestamp) 
FROM 
  your_table;

另见:MySQLFROM_UNIXTIME() 上的文档.