Hi All,

i am pulling out some dates from a db (which is stored as a date field) and am trying to get it to display on the page as e.g December 2008 instead of 2008-12-12.

i have looked on google and have found out that i need to use F and Y to format the date as i want which is fine, but what im not sure how to do is select the value to be formatted.

i have
echo $row['prodRelease'];

which prints out 2008-12-12 but i am unsure of how to format the date using the F Y???

any help appreciated :)

thanks
Luke

check out the php manual (http://php.net/manual/en/function.date.php) for date formatting options.

you will be looking to do something like.


echo date("l d'S F, y", strtotime($row['prodRelease']));


hope it helps

hi mate,

thanks for your reply,

i just found out that doing the formatting in the sql query is quicker and easier?

so i have this
SELECT *, DATE_FORMAT(prodRelease, '%e %b %y') AS formatedDate

which is currently giving me 14 Dec 09 just need to find the correct format :)

EDIT
====

found the solution
DATE_FORMAT(prodRelease, '%M %Y')

does the trick :D

thanks mate
Luke