[Resolved] Converting date from database into a readable format

[klik]

I tried the following:

$query = "SELECT DATE FORMAT(news_postdate, '%Y-%m-%d') AS news_postdate FROM cms_news WHERE news_id = '$news_id'";
$news_postdate = mysql_query($query);
$news_postdate = mysql_result($news_postdate, 0);

Hopefully someone can post the correct code for me.

Cheers

-Klik

[Mirage]

whats the format of the date in the database?

[klik]

It's a timestamp(14) type.

[devinemke]

the function is called DATE_FORMAT() not DATE FORMAT()

[klik]

Cheers dev!

[Mirage]

If you just want to display it in a readable format I normally just use the following once I have ran the query

$query = "SELECT * FROM cms_news WHERE news_id = '$news_id'";
$getnews = mysql_query($query) or die(mysql_error());
$currnews = mysql_fetch_array($getnews);

$postdate = $currnews[news_postdate];

$year = substr($postdate, 0, 4);
$month = substr($postdate, 4, 2);
$day = substr($postdate, 6, 2);
$newsdate = date('M d, Y', mktime(0, 0, 0, $month, $day, $year));

echo $newsdate; // this will dispay as Feb 10, 2005

there are a few other tweaks you can use to get the time. Hope this is what you are looking for.

[klik]

Thanks Mirage. That will definitely come in useful as well.