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.
Something like:
SELECT *, FORMATDATE(date,'%m-%d-%y') AS date FROM my_table;
or do I have to process it in php after the query?