[SOLVED] SQL datetime data type help

[waverider303]

I have a row that is a datetime datatype (2009-09-09 11:05:03) I want to retreuieve this information and have it be displayed as this: September 9th, 2009

 

This is what I have so far:

$sql = "SELECT title, content, DATE_FORMAT(`date`,'%M %D, %Y') FROM news WHERE id=$id";
$res = mysql_query($sql);
$row = mysql_fetch_assoc($res);

$date = $row['date'];
$title = $row['title'];
$content = $row['content'];
echo "<h3 class=\"cufonH3\">$title</h3>";
echo "<div class=\"dates\">".$date."</div>";
echo "<p>$content</p>";

Everything but the date displays

[p2grace]

Change your query to this:

 

$sql = "SELECT title, content, DATE_FORMAT(`date`,'%M %D, %Y') AS `date` FROM news WHERE id=$id";

[waverider303]

Worked like a charm!

 

[p2grace]

Glad to hear it

 

Could you mark the topic as solved when you get a chance?

 

Cheers,

p2grace

[gerardcorr]

http://www.mysqlformatdate.com is useful website for generating for code needed to format dates in mysql