Query returns Date (YYYY-MM-DD) and want to display as Friday, Oct 15

Question

I have a query that is grabbing the Date of a given post. I'm displaying this information in a chart that has the date and number of posts for that day. How can I display "Friday, Oct 15" instead of 2010-10-15??

Query:

$oct_week = mysql_query("SELECT COUNT(*), DATE(`dPostDateTime`) AS `day` FROM `tblQA` WHERE dPostDateTime >= '2010-10-01' AND dPostDateTime <= '2010-10-31' GROUP BY `day`");

Answer 1

Following links demonstrate how to format dates in php:

http://php.net/manual/en/datetime.format.php (concept of date formatting)

http://php.about.com/od/learnphp/ss/php_functions_3.htm (different formats)

Answer 2

DATE_FORMAT(DATE(`dPostDateTime`), '%W, %b, %e')