Converting MySQL datetime to any format
1 March 2009
No Comment
Converting the datetime format is really simple if you let MySQL do the formatting for you.
MySQL 5.1 SELECT DATE_FORMAT manual
For instance, if you wanted to convert the datetime into something that reads
function ConvertNiceDateOnly($date)
{
// Convert mySQL date to nice formatted date
$normaldate = mysql_query("SELECT DATE_FORMAT('$date','%M %e, %Y')");
$normaldate = mysql_fetch_row($normaldate);
$normaldate = $normaldate[0];
return $normaldate;
}
Leave your response!