Cdbcriteria Condition

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:


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


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

Try to get minute of the time variable this may help you