title: MySQL convert date string to Unix timestamp
body: <p>How do I convert the following format to unix timestamp?</p>
  
  <pre><code>Apr 15 2012 12:00AM
  </code></pre>
  
  <p>The format I get from DB seems to have <code>AM</code> at the end. 
  I've tried using the following but it did not work:</p>
  
  <pre><code>CONVERT(DATETIME, Sales.SalesDate, 103) AS DTSALESDATE,  
  CONVERT(TIMESTAMP, Sales.SalesDate, 103) AS TSSALESDATE
  
  where Sales.SalesDate value is Apr 15 2012 12:00AM
  </code></pre>