DateTime分组,该如何处理

DateTime分组create table task(taskId int(10),taskName varchar(100),taskCreateTime datetime)select

DateTime分组
create table task(taskId int(10),taskName varchar(100),taskCreateTime datetime);

select taskCreateTime,count(taskId) from task group by taskCreateTime;

但因为taskCreateTime是datetime类型,精确是时分秒,所以拿不到想要的统计效果,希望能够按照创建的日期Date来分组,但是又不能修改原来数据库的taskCreateTime类型

[解决办法]
select date(taskCreateTime),count(taskId) from task group by date(taskCreateTime);