title: Round up the DateTime to next Day in T-SQL?
body: <p>I have a Date which I would like to round up to next day.</p>
  
  <p><strong>For example</strong>:</p>
  
  <pre><code>SomeDate DATETIME,
  NewDate DATETIME
  
  SomeDate = '01/05/2012 8:00:0 PM'
  NewDate = Get the next day value here (in this sample it would be '01/05/2012 8:00:0 PM' + 4 Hours which is '02/05/2012 00:00:00 AM')
  </code></pre>
  
  <p><strong>So in simple words, What I want is:</strong></p>
  
  <pre><code>NewDate = '02/05/2012 00:00:00 AM'
  </code></pre>
  
  <p>Any quick way?</p>
  
  <p>Thanks!</p>