title: How to convert Char field to datetime field in mysql?
body: <p>I have datetime stored in a table as Char(30) and i want to convert them into mysql standred datetime format.</p>
  
  <p>so I tried this</p>
  
  <pre><code>   SELECT STR_TO_DATE(next_attempt, '%Y-%m-%d %T') as date FROM Table LIMIT 10;
  </code></pre>
  
  <p>This is returning Null always!
  This is the current format (5/16/2011 20:14)   so in my char(30) field i have (5/16/2011 20:14) and I want to convert it to (2011-05-16 20:14:00)</p>
  
  <p>What I doing wrong for it to keep returning Null?</p>
  
  <p>Thanks</p>