sql中常用sql语句

按天来分组查询 

select convert(varchar(10),addtime,120)  from user_online_statis  group by convert(varchar(10),addtime,120);