SELECT 1 WHERE check_time BETWEEN start_time AND end_time
or
SELECT 1 WHERE concat(check_date, ' ', check_time) BETWEEN concat(start_date, ' ', start_time) AND concat(end_date, ' ', end_time)