Date Functions MSSQL Tutorial

2>
3> select DATEDIFF(hour, '06:46:45', '11:35:00')
4> GO
-----------
          5
(1 rows affected)