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.