FROM_UNIXTIME函数格式化时间戳日期类型

select FROM_UNIXTIME(bce.daysec_time/1000,'%Y-%m-%d %h:%i:%s') ,bce.* from biz_cvent bce where bce.device_mac= '3475635C1C18' and bce.action_code=10 order by create_time desc
FROM_UNIXTIME函数格式化时间戳日期类型