DateTime按日期和小时分组 [英] DateTime group by date and hour
本文介绍了DateTime按日期和小时分组的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个名为 activity_dt 的日期时间,数据如下所示:
I have a datetime called activity_dt and the data looks like this:
2/5/2013 9:24:00 AM
2/7/2013 7:17:00 AM
如何按日期和小时分组?
How do i group by date and hour?
推荐答案
SQL Server:
SQL Server :
SELECT [activity_dt], count(*)
FROM table1
GROUP BY DATEPART(day, [activity_dt]), DATEPART(hour, [activity_dt]);
Oracle:
SELECT [activity_dt], count(*)
FROM table1
GROUP BY TO_CHAR(activity_dt, 'DD'), TO_CHAR(activity_dt, 'hh');
MySQL:
SELECT [activity_dt], count(*)
FROM table1
GROUP BY hour( activity_dt ) , day( activity_dt )
这篇关于DateTime按日期和小时分组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文