Query Builder:: Between

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'))

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…