title: SQL - how to replace a range of datetimes with a single, future datetime?
body: <p>This is a basic SQL datetime question, but I don't want to mess my database up!</p>
  
  <p>For example, in a MySQL database, if I want to replace all datetime values between date X and date Y in a single column in one of my tables - what's the SQL command to do it? Example: I want to replace all datetime values in January of this month with a future date/time in March.</p>
  
  <p>I know how to select a range of datetimes thanks to other StackOverflow questions - example:</p>
  
  <pre><code>select * from table where DatetimeField between '22/02/2009 09:00:00.000' and '23/05/2009 10:30:00.000'
  </code></pre>
  
  <p>But how to add the replace() function to this?</p>
  
  <p>Thanks in advance for your help - I've made a database backup just in case!</p>