help with dates

[Shawn Northrop]

I have a MySQL table with a date column (YYYY-MM-DD)
I am selecting this and outputting it through PHP.
Is there anyway to output it as MM-DD-YYYY ?
Also can i out put the MM as Jan Feb Mar... etc.

[billkirim]

I have a MySQL table with a date column (YYYY-MM-DD)
I am selecting this and outputting it through PHP.
Is there anyway to output it as MM-DD-YYYY ?
Also can i out put the MM as Jan Feb Mar... etc.

[PHP]
$new_timestamp = strtotime($row['date']);
$r_date = date ("m-d-Y", $new_timestamp) ;
echo $r_date;
[/PHP]

[billkirim]

[

][PHP]
$new_timestamp = strtotime($row['date']);
$r_date = date ("M-d-Y", $new_timestamp) ;
echo $r_date;
[/PHP]
This is for MM= Jan,Feb etc.

[Shawn Northrop]

awsome exactly what i needed,
thanks