title: How to Sort Varchar date in Descending order MySql?
body: <p>I'm storing datetime in varchar in my table. This my datetime format : <code>12/13/2019 12:05:30 PM</code>.
  I want to sort these date in descending order. 
  This is my sql</p>
  
  <pre><code>SELECT CreatedOn FROM advweb_usertemplatedesign Where UserId = 'fa69147ca33746cd8700a892298b11de' And ActiveStatus = 1 Order by CreatedOn Desc Limit 20
  </code></pre>
  
  <p>The result I'm getting is </p>
  
  <pre><code>12/5/2019 5:48:19 PM
  12/4/2019 4:49:10 PM
  12/3/2019 5:57:16 PM
  12/13/2019 12:05:30 PM
  12/12/2019 6:01:31 PM
  </code></pre>
  
  <p>Instead of </p>
  
  <pre><code>12/13/2019 12:05:30 PM
  12/12/2019 6:01:31 PM
  12/5/2019 5:48:19 PM
  12/4/2019 4:49:10 PM
  12/3/2019 5:57:16 PM
  </code></pre>
  
  <p>How to properly sort it? Thank you.</p>