精确到日
FROM_UNIXTIME(start_time/1000,"%Y-%m-%d")
例:计算每日创建群发的业务人数
select FROM_UNIXTIME(start_time/1000,"%Y-%m-%d"),count(cid) from ik_group_msg group by FROM_UNIXTIME(start_time/1000,"%Y-%m-%d")
精确到秒
FROM_UNIXTIME(1461201575895/1000,"%Y-%m-%d %H:%i:%s")