title: How do I add Hours, mins, seconds to dateadd sql?
body: <p>I want to get an entire date</p>
  
  <p>So today would be  7/7/2010 12:00:00 am to 7/7/2010 11:59:59 pm</p>
  
  <p>So that should be the full 24 hours since 12:00:00 am would be the 8th then. </p>
  
  <p>So I have this</p>
  
  <pre><code>select DATEADD(??, ??, DATEDIFF(dd, 0, GETUTCDATE()))
  </code></pre>
  
  <p>How do I make it add 23 hours 59mins and 59seconds to it?</p>