title: MySQL DATETIME - Change only the date
body: <p>Starting with : 2011-01-17 09:30:00</p>
  
  <p>Let's say I want to edit just the date with 2011-01-28</p>
  
  <p>What is the most efficient way to end up with: 2011-01-28 09:30:00</p>
  
  <p>Thanks!</p>
  
  <p>For everyone saying Date_Add... that would require me to subtract the dates, then add the days.  Thats a possibility... but was looking to remove that first step, and just "replace" the date</p>