Month name from date

[rcr]

Hi All,

I am having a hard time trying to display the month name (as in January, February) from a date that is stored in the database. Suppose I have a date value '2012-09-06' coming from the database, I want to perform the action to display the month as September (the 09 from the date). Can someone please let me know how to do this.

Also if you can direct me to simple explanation or tutorial on how to format dates I would greatly appreciate it.

Thanks for your time.

RCR

[Derokorian]

You could get the month name when pulling the date from the DB using MONTHNAME()
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

You could also use [man]strtotime/man and [man]date/man to do it in PHP.