title: Convert string datetime in non-standard format into DATETIME on INSERT into MySQL
body: <p>If I have a string that represents the date and time such as '30/09/2011 10:14' which is a non-standard DATETIME format. Can I reformat this to a standard DATETIME format on insert into a DATETIME field in a MySQL database table?</p>
  
  <p>I have tried this:</p>
  
  <pre>
  INSERT INTO test(lastdate) VALUES(DATE_FORMAT('30/09/2011 10:14', '%d/%m/%Y %H:%i'))
  </pre>
  
  <p>The result is NULL in the lastdate DATETIME field.</p>