title: How do you convert a string to a date in mysql?
body: <p>I must be doing something wrong.  I'm trying to search the database on a OrderDate column which is stored as a string ex. "7/21/2016 9:13:31 PM"
  AND I want to convert OrderDate to a unix timestamp for the query statement :</p>
  
  <pre><code>UNIX_TIMESTAMP(STR_TO_DATE(OrderDate,  '%e/%c/%Y %r')) &gt;= 
  '1471496400' AND UNIX_TIMESTAMP(STR_TO_DATE(OrderDate, '%e/%c/%Y
  %r')) &lt;= '1471669199'
  </code></pre>
  
  <p>There are plenty of results in the table that should match this. But I'm not getting any of them. What am I doing wrong?</p>
  
  <p>I've read the manual and searched the internet and cannot figure out what I am doing so please don't tell me to RTM </p>