最新消息: 新版网站上线了!!!

yii FROM_UNIXTIME在CDbCriteria的用法

$today = '2015-01-13'; // today
         
         $format = '%Y-%m-%d';
         
         /* get news for today */
         $lnCriteria = new CDbCriteria();
         $lnCriteria->condition = "(FROM_UNIXTIME(`addtime`, :format) = :date)";
         $lnCriteria->params = array(':format'=>$format, ':date'=>$today);
         
         $lnCriteria->order = '`addtime` DESC';
         $lnCriteria->limit = 26;
         $todayNews = News::model()->findAll($lnCriteria);
 
         echo count($todayNews); exit;

转载请注明:谷谷点程序 » yii FROM_UNIXTIME在CDbCriteria的用法