bigint类型时间转date类型： DATE_FORMAT(FROM_UNIXTIME(start_time/1000),’%Y-%m-%d %H:%i:%S’) as start_time, DATE_FORMAT(FROM_UNIXTIME(end_time/1000),’%Y-%m-%d %H:%i:%S’) as end_time, bigint类型时间运算精确到毫秒(单位/分)： convert(IFNULL(TIMESTAMPDIFF(SECOND,DATE_FORMAT(FROM_UNIXTIME(start_time/1000),’%Y-%m-%d %H:%i:%S’), DATE_FORMAT(FROM_UNIXTIME(end_time/1000),’%Y-%m-%d %H:%i:%S’))/60,0),decimal(12,2)) , 结束时间减去开始时间运算： convert(IFNULL(TIMESTAMPDIFF(SECOND,DATE_FORMAT(FROM_UNIXTIME(b.start_time/1000),’%Y-%m-%d %H:%i:%S’) ,DATE_FORMAT(FROM_UNIXTIME(b.end_time/1000),’%Y-%m-%d %H:%i:%S’))/60,0),decimal(12,2)) convert_time
