title: Convert Date Format in Update Query
body: <p>I'm trying to perform and update query that updates the date in a database. Please note, I'm using a version of SQL Server older than 2008 so I cannot use the Date type.</p>
  
  <pre><code>UPDATE TABLE
  SET TABLE.DATECOLUMN = @input_date
  </code></pre>
  
  <p>I'm trying to do something like below, I want the date entered to essentially get rid of the time in datetime, so set it to midnight.</p>
  
  <pre><code>UPDATE TABLE
  SET DATEADD(d, DATEDIFF(d, 0, TABLE.DATECOLUMN)) = @input_date
  </code></pre>