jowen
(Ljowen985)
1
Hi guys,
how to write the sql statement in query builder::between??
SELECT * FROM sale WHERE DATE(local_created)BETWEEN '2011-10-01' AND '2011-10-07'
$sql=Yii::app()->db->createCommand()
->select ('*')
->from sale
->where(array("date(local_created) between", array('2011-10-01', '2011-10-07'))
dckurushin
(Diavolonok)
2
I think there is not a simple way to do it
for example you can see how hard it is to increment counter via query builder
http://www.yiiframework.com/wiki/258/common-yii-questions/#hh8
so here you also have the same issue… if it is not built in - use DAO
but maybe I wrong…