title: MySql 'Order by Date' Question
body: <p>Im pulling data from a MySql data table.  I'm pulling from a row called 'PubDate' (meaning Published date).  This format is in Date format, not DateTime.  When I execute the query </p>
  
  <pre><code>Select * from Articles order by pubDate ASC
  </code></pre>
  
  <p>Its ordered by date as so:</p>
  
  <p>1.09/18/09
  2.09/18/09
  3.09/19/09
  4.09/20/09</p>
  
  <p>If possible I would like to be able to get the most recent date first by using the 'ASC' value for direction due to my current code logic.  I've already tried </p>
  
  <pre><code>Select * from Article order by Cast(pubdate as datetime) ASC 
  </code></pre>
  
  <p>but didn't change the output.  I CAN do DESC (descending order) if I must...but its not preferable.  </p>