title: Convert string with different format to date
body: <p>I have a table with a string column (<em>varchar(200)</em>) that contain a date in different format. For example</p>
  
  <pre><code>may 24 1983 12:00AM
  1981-01-13 00:00:00
  1979-01-13 00:00:00:123
  </code></pre>
  
  <p>I want to convert this column in a date to extract year. How could i do? I have used STR_TO_DATE but don't work well. I must use SUBSTRING for each different format?</p>
  
  <p>MySQL version 5.0.95</p>