如果您使用的是 SQL Server,
dateadd(DAY,0, datediff(day,0, created))
将返回创建的日期
例如,如果销售是在“2009-11-02 06:12:55.000”创建的,dateadd(DAY,0, datediff(day,0, created))
返回 '2009-11-02 00:00:00.000'
select sum(amount) as total, dateadd(DAY,0, datediff(day,0, created)) as created
from sales
group by dateadd(DAY,0, datediff(day,0, created))