title: SQL datetime update time to 00:00:00 from all other time values
body: <p>Is there a way to update all columns in table from</p>
  
  <pre><code>2010-12-31 23:59:59.000
  </code></pre>
  
  <p>to</p>
  
  <pre><code>2010-12-31 00:00:00.000
  </code></pre>
  
  <p>Something like this??</p>
  
  <pre><code>UPDATE t1
  SET [Posting Date] = [Posting Date] with ms = 00:00:00.000
  WHERE ms = other than 00:00:00.000
  GO
  </code></pre>