T-SQL DateDiff - 按“完整小时前”分区，而不是“自从分钟开始转换为00的时间”

I have a table with timestamps, and I want to partition this table into hour-long intervals, starting at now and going backwards a couple of hours. I'm unable to get the results I need with the T-SQL I have a table with timestamps, and I want to p