DateTime group by date and hour

Question

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

User · Accepted Answer

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

User · Answer

In my case    with MySQL  SELECT     GROUP BY TIMESTAMPADD HOUR  HOUR columName   DATE columName

User · Answer

Using MySQL I usually do it that way   SELECT count  id        FROM quote data GROUP BY date format  your date column    Y m d H    order by your date column desc    Or in the same idea  if you need to output the date hour    SELECT count  id     date format  your date column    Y- m- d  H    as my date FROM  your table  GROUP BY my date order by your date column desc    If you specify an index on your date column  MySQL should be able to use it to speed up things a little

User · Answer

SELECT  activity dt   COUNT    as  Count    FROM    SELECT dateadd hh  datediff hh   20010101    activity dt     20010101   as  activity dt      FROM table  abc  GROUP BY  activity dt

[mysql] DateTime group by date and hour

Examples related to mysql

Examples related to sql