Cdbexpression In Select Criteria

Yii 1.1 General Discussion
1

i have next query for sqlite




$q =<<<SQL

SELECT strftime('%Y-%m-%d',created_date), book_guid, title, year

FROM books

$where

ORDER BY $sidx $sord

LIMIT $start, $limit

SQL;

how i think but it doesn’t work




$c = new CDbCriteria();

$c->select = [new CDbExpression("strftime('%Y-%m-%d',created_date)"),  //FAIL

'book_guid', 'title', 'year'];

$c->order = "$sidx $sord"; //safe

$c->limit = 1;

...

$r = Books::model()->findAll($c);

so, how can i pass strftime(’%Y-%m-%d’,created_date) to query