Really Simple Date Question

[Mateobus]

OK, i have a mySQL table with date elements in the format YYYY-MM-DD. How do I display these dates nicely in PHP Like:

Month Day, Year, or just Month, Day

I looked for a couple tutorials but didn't find much. I feel like there should be a really simple way to do this.

[Barand]

if $row['datecol'] is the column from your table and contains today's date, then

[code]echo date ('M jS, Y', strtotime($row['datecol']));[/code]

--> Apr 24th, 2006

[PWD]

You can also do it at your query level as well:

[code]$query= "Select DATE_FORMAT(date_date,'%M %D %Y') AS sortdate from your_table ORDER BY date_date ASC"; /* ORDER BY function orders ascending (ASC) or descending(DESC) */

echo $sortdate;
[/code]

Also, search the MySQL site for the different formats you can use for DATE_FORMAT()...