SQL日期選取

我的資料庫裡有個表是日期的
news_last_modified
2013-04-12 13:04:18

是這個樣式的。

如何只選擇日期而不選擇時間呢？
前台的代碼是這樣的

require_once(DIR_WS_CLASSES . 'news.php');

$news_list_by_author_sql='select n.article_id,n.news_last_modified, nt.news_article_name from ' . TABLE_NEWS_ARTICLES . ' n left join ' . TABLE_NEWS_ARTICLES_TEXT . ' nt on (n.article_id = nt.article_id and nt.language_id = \'' . (int)$_SESSION['languages_id'] . '\') and n.news_status = \'1\'' . ' order by n.article_id DESC limit 6 ';
$news = $db->Execute($news_list_by_author_sql);

if ($news->RecordCount() > 0) {
$i = 0;
$article_array = array();
while (!$news->EOF) {
$article_array[$i] = array(
'articleId' => $news->fields['article_id'],
'articledate' => $news->fields['news_last_modified'],
'articleName' => stripslashes($news->fields['news_article_name']),
);
$i++;
$news->MoveNext();
} //end while
} else {
$articlesNotFound = true;
}

?>
-------------------------------------
'articledate' => $news->fields['news_last_modified']

麻煩大家幫個忙。我是個新手。正在學習中

回複討論(解決方案)

date()

$str="2013-04-12 13:04:18";$ar=explode(" ",$str);print_r($ar);//Array ( [0] => 2013-04-12 [1] => 13:04:18 )$t=explode(" ",$news->fields['news_last_modified']);'articledate' => $t[0],

$news_list_by_author_sql='select n.article_id, date_format(n.news_last_modified,"%Y-%m-%d") as news_last_modified , nt.news_article_name from ' . TABLE_NEWS_ARTICLES . ' n left join ' . TABLE_NEWS_ARTICLES_TEXT . ' nt on (n.article_id = nt.article_id and nt.language_id = \'' . (int)$_SESSION['languages_id'] . '\') and n.news_status = \'1\'' . ' order by n.article_id DESC limit 6 ';

或者在php裡面轉也可以

'articledate' => date("Y-m-d",strtotime($news->fields['news_last_modified'])),

$news_list_by_author_sql='select n.article_id,date_format(n.news_last_modified,"%Y-%m-%d") as news_last_modified , nt.news_article_name from ' . TABLE_NEWS_ARTICLES . ' n left join ' . T……


感謝.現在明白了大概要怎麼弄了.調試了一下也出來相應的效果.滿分

