select FROM_UNIXTIME(addtime,'%Y年%m月%d %h:%i:%s') from users 转载于:https://www.cnblogs.com/shanrui/p/6248986.html