SELECT *,FROM_UNIXTIME(addtime, '%Y-%m-%d %H:%i:%S') as riqi FROM `test` 转载于:https://www.cnblogs.com/jackspider/p/4157825.html