下面的例子在oracle中工作得很好

select to_char(columnname, 'DD/MON/yyyy'), count(*) from table_name group by to_char(createddate, 'DD/MON/yyyy');

将值转换为组的日期类型。

GROUP BY CAST(myDateTime AS DATE)

GROUP BY DATE(date_time_column)

下面是我使用的一个例子，当我需要计算特定日期的记录数量而不包括时间部分时:

select count(convert(CHAR(10), dtcreatedate, 103) ),convert(char(10), dtcreatedate, 103)
FROM dbo.tbltobecounted
GROUP BY CONVERT(CHAR(10),dtcreatedate,103)
ORDER BY CONVERT(CHAR(10),dtcreatedate,103)

下面的例子在oracle中工作得很好

select to_char(columnname, 'DD/MON/yyyy'), count(*) from table_name group by to_char(createddate, 'DD/MON/yyyy');

好吧，对我来说，它几乎是直接的，我使用cast和groupby:

例子:

Select cast(created_at as date), count(1) from dbname.tablename GROUP BY cast(created_at as date)

注意:我在MSSQL 2016上使用这个。