MSSQL - Round date to the last hour

 Watch this example on YouTube

 

SELECT DateAdd(hour, datediff(hour, 0, getdate()),0)