开发者

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

I have a query that is grabbing the Date of a given post. I'm displaying this informati开发者_如何学Goon 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`");


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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜