hi all, i have this condtion in my model search function
$criteria->addCondition('sched.time_from <= checking.time AND sched.time_to > checking_time');
my table sample:
schedule
id time_from time_to
1 07:00:00 08:00:00
2 09:00:00 10:00:00
3 11:00:00 12:00:00
checking
id time
1 07:15
2 08:18
3 11:18
with the above code i get all schedule if the checking.time is equal to sched.time_from or between the sched.time_from and sched.time_to…
now my question is in the above code i want to get all schedule that checking.time is greater that 16minutes, how can i combine using the above code