title: STR_TO_DATE() function of MySQL
body: <p>I have date in this format <code>5 Mar 1985  0:00</code> stored in table as <code>VARCHAR</code>.<br>
  I want to convert it into <code>Datetime</code>, I am using the <code>STR_TO_DATE()</code> as follows:</p>
  
  <pre><code>SELECT STR_TO_DATE(birth_date, '%d %m %Y %h:%i') FROM student WHERE pk = 29
  </code></pre>
  
  <p>But it returns <code>NULL</code>. </p>