[RESOLVED] convert MySQL datetime to "mm/dd/yyyy"

[ppowell]

Sorry I have no clue how to do this one.

I'm having to convert a MySQL datetime in the format YYYY-MM-DD HH:MM:SS to MM/DD/YYYY

Bluntly put, how do you do it?

Thanx
Phil

[ppowell]

I shouldn't have posted this, sorry. Too stupid to ask.

 date('m/d/Y', strtotime($result[$i]->my_date));

Phil

[devinemke]

don't do the formatting in PHP. use mySQL's Date and Time Functions (specifically DATE_FORMAT)