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?
See Question&Answers more detail:osI 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?
See Question&Answers more detail:osSQL 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 )