title: How to format a date field in mysql?
body: <p>I am having a problem in mysql query, I have date saved in database in this format :</p>
  
  <blockquote>
    <p>Wed, 26 Oct 2011 01:25:35 EDT</p>
  </blockquote>
  
  <p>I want to sort the rows by date but this date format is not letting me do it. I have tried <code>Date_FORMAT</code> AND <code>STR_TO_DATE</code> function but couldn't get it working, could you please help me solve this?</p>