mysql unix 时间戳转换

select convert_tz(date_format(from_unixtime(left(record_time,10)), '%Y-%m-%d %H:%i:%S'),"+00:00","+08:00") from xxx