John-l had a vaid solution, but the trick is to remember that PHP likes UNIX timestamps (seconds since UNIX zero, Jan. 1, 1970). To format, it is always best to convert the datetime (etc) formats to UNIX timeformat, THEN format for display.
This -- to me -- is a bit awkward (Cold Fusion, ASP handle this better), but it is VERY flexible, which is a good point.
My mySQL database has the date_added field that = 2002-08-03 16:35:19, for example.
Assume the following is PART of a query called "rValid", but you get the idea:
// query result
$date_added = mysql_result($rValid, 0, "date_added");
// convert to UNIX timestamp
$date_added = strtotime($date_added);
// format properly
$date_added = date("F j, Y", $date_added);
This will now display -- by calling the variable $date_added -- "August 1, 2002" or whatever.
The F,j and Y are mask variables; if you want the mm/dd/yyyy mask make the last line the following:
$date_added = date("d/m/Y", $date_added);
See the date() function for mask values.
