How can I add Hour and minute in a single query
<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>