查询格式: timestamp字段为字符串:FROM_UNIXTIME(CONVERT(timestamp/1000,signed), ‘%Y-%m-%d %T’) 如: select start_time,FROM_UNIXTIME(CONVERT(start_time/1000,signed),'%Y-%m-%d %T') as starttime,FROM_UNIXTIME(CONVERT(end_time/1000,signed),'%Y-%m-%d %T') as endtime,end_time from tablename;