Select * from table where time like' _ _ _ _ _ _ _ 09:' or time like' _ _ _ _ _ 09:' or time like' _ _ _ _ _ _10:'

If what is stored in the repository is (15:57:3 1)

select * from table where time ' 8:00 ' between ' 9:00 '