原数据

sql 

SELECT  id,month,person_id,source_type,check_type,time_result,location_result,is_legal, FROM_UNIXTIME(round(work_date/1000,0)) as work_date, FROM_UNIXTIME(round(check_time/1000,0)) as check_time, FROM_UNIXTIME(round(create_time/1000,0)) as create_time  FROM `attendance_info` ORDER BY create_time

推荐博客 

mysql—MySQL数据库中10位或13位时间戳和标准时间相互转换 - 马踏飞燕Beautiful - 博客园 (cnblogs.com) 

小白一枚，大神绕道