title: How can I convert datetime to date, truncating the times, leaving me the dates?
body: <p>I have a field that's in datetime format when date would be better and more consistent with the rest of the database, so I want to convert. The time part is all 00:00:00 anyway.</p>
  
  <p>How can I do this in MySQL?</p>
  
  <p>Thanks.</p>