Outputting a date?

[stfc_boy]

Hi All,

I have a date in my database in this format 2008-08-01 12:00:00

So when I want to print the date to my actual site I use this query:

PHP Code:

SELECT *, DATE_FORMAT(published, '%W, %D %M, %Y') AS formatted_date 


Which outputs: Friday, 1st August, 2008
But how would I output the date in this format: Fri 8th Aug (No Year)
Thanks
Chris

[abduraooft]

Have you checked http://dev.mysql.com/doc/refman/5.0/...on_date-format
To remove the year, just remove , %Y part. Or do you want to change the date from 1 to 8 ?