title: Date sorting in MySQL
body: <p>I am capturing dates in the following format:</p>
  
  <pre><code>Mon, February 14, 2011, 08:22:34 AM
  </code></pre>
  
  <p>When I sort posts by the most recent date/time by using ORDER BY date_time DESC, sometimes it sorts it correctly and sometimes it doesn't. So is there a better way to capture data so that the sorting will be done correctly?</p>
  
  <p>For instance, work ten entries in a row it might sort properly, that is it will show the most recent posts first. Then after that it might put the most recent one at the very bottom</p>