时间戳
select FROM_UNIXTIME(yourtime,'%Y%m%d') as days，uid from yourtable group by days
Datetime
select DATE_FORMAT(yourtime,'%Y%m%d') as days，uid from yourtable group by days
