title: MS SQL Update Date Only
body: <p>All,</p>
  
  <p>Is there a way in SQL to update a datetime field and only change the date? I have a year's worth of data in datetime format (YYYY-MM-DD XX:XX:XX.XXX) and would like the set date for every value to be 12/30. I do not want to change the time or the year. </p>
  
  <p>I tried the following but with no luck:</p>
  
  <pre><code>UPDATE table
  SET DATEPART(MONTH,[date]) = 12 WHERE DATEPART(YEAR,[date]) = 2016
  </code></pre>
  
  <p>Any suggestions?</p>
  
  <p>EDIT: Using SQL Server 2008</p>