Tags

Code:
SELECT TRUNC(datecol, ‘HH24’) FROM mytable
GROUP BY TRUNC(datecol, ‘HH24’);

from http://stackoverflow.com/questions/5111396/sql-group-by-date-hour (I liked this solution better)