title: Updating date in mySql
body: <p>I have a DATE column with dates in 2012-02-25 format. I need to update it to 12-02-25 but am not sure how to go about it?</p>
  
  <p>Thanks!</p>
  
  <p>Edit: After reviewing all the answers, it seems I have not been clear enough. I do not wish to change my type, nor do I wish to play with the output. I want to update the existing date column from 2012 to 12. It should be an UPDATE query if anything, I'm just not sure how to write it. Thanks for all the comments so far.</p>
  
  <p>Edit 2: It seems my question did not make sense, I was not aware you could not store DATE as xx-xx-xx. Thanks anyhow!</p>