SQlite ADDTIME()

Yii 1.1 General Discussion
1

Can someone help me translate a MySQL line to work in SQlite?


	SELECT * FROM `Schedule`

	WHERE (FIND_IN_SET(SUBSTRING(DAYNAME(CURRENT_DATE),1,3), `airDays`) 

	AND (addtime(`airTime`, sec_to_time(`duration`)) >= CURRENT_TIME))

	ORDER BY `airDate`, `airTime`, `isSpecial` DESC LIMIT 2

I have gotten:


	$criteria=new CDbCriteria(array(

//	   'condition'=>'(`airTime`+time(`duration`)) >= CURRENT_TIME',

	   'order'=>'`airDate`, `airTime`, `isSpecial` DESC',

	   'limit'=>2,

	));

	$criteria->addSearchCondition('airDays',date('D'),'AND');


	$data=Schedule::model()->findAll($criteria);

I just can’t think of how to get what is currently happening (the addtime() section).

Thanks in advance.

2

Anybody?

3

I guess not :(