title: How can I add Hour and minute in a single query
body: <p>How can I add hours and minutes in a single query?</p>
  
  <p>I tried this</p>
  
  <pre><code>Select DATEADD(hh,23.59,CAST('2016-07-08' AS DATETIME))
  </code></pre>
  
  <p>I need to ad 23 hours and 59 minutes, but my code only adds the hours.  Why?</p>