Changing Date format

[Anon]

I have a table in MySQL that stores a list of dates and activities, and the data is then displayed in a web page.
The date field uses the MySQL function "date" and is stored in YYYY-MM-DD format.
This is fine for storage in the table but I would like to display it in MM-DD-YYYY format on the web page.
I haven't really learned how to parse in PHP yet so I would appreciate a code snip that will show me how to do this. Thanks.

[Anon]

You can either have MySQL do it for you:

SELECT DATE_FORMAT(theDate, '%m-%d-Y') AS newDate ...

or use mktime(...) function in PHP:

$year = strtok($theDate, "-");
$stamp = mktime(0,0,0,$year,strtok("-"),strtok("-"));
print "newDate = ".date("m-d-Y", $stamp);

[Anon]

Wow! That was fast. Thanks for your response. I'm going to try this in my code right away. Thanks again.