清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

SELECT DATEADD(hh,DATEDIFF(hh,0,Date),0) [Hour]
  FROM [t1] 
  group by DATEDIFF(hh,0,Date)