title: Update in sql server 2012 only time part of a date
body: <p>Is there a way to perform an update in a sql server 2012 database but only of the time part?</p>
  
  <p>I have this data:</p>
  
  <pre><code>id | date
  1  | 2013-09-01 15:25:58.526
  2  | 2013-05-10 12:12:34.345
  3  | 2013-05-10 11:23:33.234
  4  | 2013-04-07 15:34:01.345
  </code></pre>
  
  <p>And i want to change all the times to 00:00:00.000... how can i do that?</p>