CActiveRecord中使用group语句问题
数据列id, time char(14), money float(12,2)ActiveRecord属性id, time, money现在想查找select left(time, 8), sum(money) from _table_ group by left(time, 8) order by time asc怎么处理呢------------------- $criteria_income = new CDbCriteria(); $criteria_income->select = 'left(time, 8) AS time, sum(money) AS money'; // $criteria_income->addBetweenCondition('time', $start_date, $end_date); $criteria_income->group = 'left(time, 8)'; $criteria_income->order = 'time ASC';