mysql to us date formatting

Hi there,

Trying to take mysql date format and output it as us standard YYYY-DD-MM however it seems to be ignoring my date.. here is my code...

<?
$oldDate="2005-12-01";
$newDate = date("m-d-Y", $oldDate);
echo $newDate;
?>
// This returns :
1970-01-01

Any ideas?
Cheers,
Sir P

This is a php question not a mysql question but

<?
$oldDate="2005-12-01";
$newDate = date("m-d-Y", strtotime($oldDate));
echo $newDate;
?>

Doh sorry :/

Thanks for the code :)

You can do it directly in mysql instead of having to do any of the work in php, just use DATE_FORMAT.