1. 时间戳格式化
sql
DATE_FORMAT(FROM_UNIXTIME(wg.datetime), '%Y-%m-%d %H:%i:%s')示例
sql
SELECT id,DATE_FORMAT(FROM_UNIXTIME(create_time), '%Y-%m-%d %H:%i:%s') as create_time FROM `student`