title: DATE_FORMAT() in MySQL query
body: <p>I'm trying to change this timestamp</p>
  
  <blockquote>
    <p>2010-08-02 00:28:20</p>
  </blockquote>
  
  <p>to month/day/year - </p>
  
  <blockquote>
    <p>08/02/10</p>
  </blockquote>
  
  <p>..in the query (I know that doing it in the query is faster).</p>
  
  <pre><code>$sql = "SELECT * FROM posts ORDER BY post_date DESC";
  </code></pre>
  
  <p>I tried using the DATE_FORMAT() in the query many ways but I can't seem to get it right.. Can someone please share how to do this?</p>