title: MySQL; ORDER BY STR_TO_DATE doesn't work vice versa
body: <p>This is my code:</p>
  
  <p><code>SELECT id, title, date FROM table ORDER BY STR_TO_DATE(date,"%m/%d/%Y %h:%i:%s")</code></p>
  
  <p>The date output is:</p>
  
  <pre><code>2016-12-11 14:40:00
  2016-11-15 08:50:09
  2016-11-15 08:54:58
  </code></pre>
  
  <p><code>SELECT id, title, date FROM table ORDER BY STR_TO_DATE(date,"%m/%d/%Y %h:%i:%s") DESC</code>
  doesn't work for me for some reason.</p>
  
  <p>How can I reach to ORDER BY this?</p>
  
  <pre><code>2016-11-15 08:54:58
  2016-11-15 08:50:09
  2016-12-11 14:40:00
  </code></pre>
  
  <p><strong>Edit: <code>date</code> is stored as <code>timestamp</code> in my MySQL database!</strong></p>