FROM_UNIXTIME(unix_timestamp,format):把时间戳转化成日期时间SELECT FROM_UNIXTIME(1452959999) SELECT FROM_UNIXTIME(1452959999,'%Y-%m-%d %H:%i:%s')登录后复制-> 2016-01-16 23:59:59 -> 2016-01-16 23:59:59登录后复制