按时间分组 [英] Group by date without time

问题描述

我想知道是否有办法将2014-01-26 05：39：29.000和2014-01-26 07：45：31.000中的日期划分为一天。

I was wondering whether there was a way to group dates that are 2014-01-26 05:39:29.000 and 2014-01-26 07:45:31.000 into one day when counting them. I currently have the following code that just groups them by there unique datetime.

    SELECT ETK_ExpirationDateTime, COUNT(*) as TotalRows
    FROM History_Action 
    WHERE [State] = 4
    GROUP BY ETK_ExpirationDateTime
    ORDER BY ETK_ExpirationDateTime 

是否有演员或我可以做的事情使上述2个日期显示为一行总计？

Is there a cast or something I can do to make those 2 dates above appear as one row with a total sum?

推荐答案

SELECT CAST(ETK_ExpirationDateTime AS DATE) AS DATE, COUNT(*) as TotalRows
FROM History_Action 
WHERE [State] = 4
GROUP BY CAST(ETK_ExpirationDateTime AS DATE)
ORDER BY 1

这篇关于按时间分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！