title: Format date in SELECT * query
body: <p>Is it possible to format a date field in a SELECT * query? I want to get all of the columns from my table but need a different format from the date.</p>
  
  <p>Something like:</p>
  
  <pre><code>SELECT *, FORMATDATE(date,'%m-%d-%y') AS date FROM my_table;
  </code></pre>
  
  <p>or do I have to process it in php after the query?</p>