title: Converting mysql date from one format to another
body: <p>I have date stored in a field like this: 31st Dec 2013 but I need to alter it to something like this: 2013-12-31 00:00:00</p>
  
  <p>I have tried lots of variations of DATE_FORMAT and strtotime but got nowhere.  How do I go about this please?</p>
  
  <p>Thanks</p>