select CONVERT(varchar, year(CreateTime)) +'年'+CONVERT(varchar, month(CreateTime)) + '月'+CONVERT(varchar, day(CreateTime)) +'日', COUNT(1) as total from t_test ul where CreateTime>'2019-05-01' group by year(CreateTime),month(CreateTime),day(CreateTime)
结果图:
如果本文引用了你的文章而未注明,请及时联系我。