 <p>Keep it simple, son.</p> <pre><code>declare @date1 datetime declare @date2 datetime select @date1 = GETDATE(); select @date2 = '2013-02-02 14:05' select DATEDIFF(hh, @date2, @date1) Results ----------- 71 (1 row(s) affected) </code></pre>