Formatting Dates

I'm trying to format my date in a database table. Is there a way to do it in the mysqladmin or how do you have to do? It appears right now like 2008-08-08 but I want it to appear like July 8, 2008

I have it in my php code as:

<p><b>Date Won</b><br>'.$row['datewon'].'

Where you fetch datewon from the query, just modify it to

SELECT field1, field2, etc, DATE_FORMAT('datewon', '%M %e, %Y') WHERE whatever='who';

After I put this in and tried to run it. It said that there was an unexpected T_String

$query = 'SELECT *, DATE_FORMAT('datewon', '%M %e, %Y') FROM titles';

Change the 1st and last single quotes to double ones, eg " instead of '

$query = "SELECT *, DATE_FORMAT('datewon', '%M %e, %Y') FROM titles";

The single quotes in the date_format() were breaking the line

I got it to show atleast but it isn't formatting it correctly still.

Ok, try this maybe


$query = "SELECT *, DATE_FORMAT('datewon', '%M %e, %Y') AS dateofwin FROM titles";

Then call $row['datewon'] as $row['dateofwin'] instead

I'm doing this completely off memory as haven't done this for about 5 years