Menu
I have this snippet of my script:
[code=php]$sql_news = “SELECT new_post, news_title, news, DATE_FORMAT(date, ‘%b %d, %Y’) AS FormatDate FROM news ORDER BY news_id DESC”;
$show_news .=”<td align=’left’>” . $news_post[‘FormatDate’] . “</td>”;
What my problem is I want to echo including the time. In my table, the value of column ‘date’, is say for example “2010-03-28 13:07:38”.
Using my script the $show_news only prints “Mar 28, 2010”., my want output is “Mar 28, 2010 1:07:38pm”.
Any suggestions using DATE_FORMAT modification?