title: DATEDIFF Round off cutoff date hours SQL Server
body: <p>My client has this KTV hour rule all check out above 20 mins will be considered as additional 1 hour.</p>
  
  <p>Example code below: </p>
  
  <pre><code>  declare @dateStart as datetime, @dateEnd as datetime
  
    set @dateStart = cast('3/2/2013 8:00:00 PM' as datetime)
    set @dateEnd   = cast('3/2/2013 9:20:02 pm' as datetime)
  
    SELECT DATEDIFF(hour, @dateStart, @dateEnd) 
  </code></pre>
  
  <p>The code above logically returns 1:20 hours. In SQL server it will return 1 hour. How can I tweak this code to return as 2 hours?</p>
  
  <p>Thanks in advance.</p>