title: Using REPLACE to change datetime with SET
body: <p>I haven't used this website before and am <em>very</em> new to SQL so please excuse any errors or if this question has been raised incorrectly - I have been asked to do something that is well outside of my remit and skill level!</p>
  
  <p>I have many rows of data with a particular column - <code>COLUMN</code> - which has a <code>DATETIME</code> datatype, in a particular table - let's call it <code>_data</code>, and the data within it looks like this: <code>2019-11-12 17:00:00.000</code></p>
  
  <p>I want to replace the YY-MM-DD portion of all of the columns in this table with today's date, <code>2019-11-28</code>.</p>
  
  <p>I am trying this code:</p>
  
  <pre class="lang-sql prettyprint-override"><code>update DATABASE.dbo._data
  set COLUMN = REPLACE(COLUMN,'2019-11-13','2019-11-28')
  </code></pre>
  
  <p>Which executes and informs me that every row in <code>DATABASE</code> has changed, but when I look at the data with a <code>SELECT</code> statement, it is the same as it was before. Why is this, do I need to do something different because the datatype is <code>DATETIME</code>? Google did not elucidate me and neither did w3schools or the other questions I searched for on here, but that's probably because I have no idea what I am doing.</p>
  
  <blockquote>
    <p>I am using <strong>SQL SERVER 2012 on a Windows Server 2012 R2</strong> box and I am running this code with SQL Server Management Studio v18.4. </p>
  </blockquote>