使用mysql的DATE_FORMAT函数对日期进行格式化,根据日期进行分组,sql如下:
select DATE_FORMAT(create_time,'%Y-%m-%d') days,count(*) from user where create_time>'2017-3-1' group by days
使用mysql的DATE_FORMAT函数对日期进行格式化,根据日期进行分组,sql如下:
select DATE_FORMAT(create_time,'%Y-%m-%d') days,count(*) from user where create_time>'2017-3-1' group by days
转载于:https://my.oschina.net/u/3337958/blog/855543