MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE status_list
             (status tinyint,
              time_start time,
              time_end time);
INSERT INTO status_list
            VALUES (2, '14:00:12', '14:13:33'),
                   (5, '14:13:33', '15:33:41'),
                   (9, '15:33:41', '16:02:11');
SELECT status,
       CASE
         WHEN time_start < '15:00:00' THEN
           '15:00:00'
         ELSE
           time_start
       END time_start,
       CASE
         WHEN time_end > '16:00:00' THEN
           '16:00:00'
         ELSE
           time_end
       END time_end
       FROM status_list
       WHERE time_start >= '15:00:00'
             AND time_start < '16:00:00'
              OR time_end >= '15:00:00'
                 AND time_end < '16:00:00';


status
time_start
time_end


5
15:00:00
15:33:41

9
15:33:41
16:00:00