[RESOLVED] Date format variable

[juniper747]

I have a date stored in my database in this format:
2009-06-31

In my code I also have it stored as a variable:

$myentrydate;

I want to retrieve it and be able to print it out on a page like this:

June 31, 2009

or

Wednesday, June 31, 2009

How can do it?

[Derokorian]

echo date("F j, Y",strtotime($myentrydate));

Should do the trick for the first format, to get the exact formatting you desire please see the date manual for available output.
http://php.net/manual/en/function.date.php

[bradgrafelman]

To me, it makes more sense to SELECT the data as you want it rather than trying to manipulate it in PHP.

In other words, I personally would use MySQL's DATE_FORMAT() function to SELECT the date in whichever format I desire.

[juniper747]

Sounds good, thanks!