title: MySQL: str_to_date multiple formats
body: <p>I have a ETL cleanup project where I have a unioned date column that includes formats such as "2014-10-14" and "10/14/2014 12:00:00 AM". I am trying to find a slick way I can convert them all using a str_to_date function either in a case statement or some other way to help determine which format it is and then convert it to a date.</p>
  
  <p>So far all my efforts have failed. Any thoughts?</p>