SQL中使用年月日来进行分组 SQL按年月日进行分组 select count(project_name), create_at from table_a group by date_format(create_at, '%Y%m%d');