Retrieve the shiftTypeID according time

Dear Friends, i want retrive the Shift_TypeID according to the time wise... Table Structure  --CREATE TABLE [dbo].[Shifts]( -- [ShiftID] [int] IDENTITY(1,1) NOT NULL, -- [Shift_TypeID] [int] NOT NULL, -- [ShiftStartTime] time NOT NULL, -- [ShiftEndTime] time NOT NULL, --) --insert into shifts(Shift_TypeID,SHiftSTartTime,ShiftEndTime) values('1','9:00','12:00') --insert into shifts(Shift_TypeID,SHiftSTartTime,ShiftEndTime) values('2','12:00','18:00') -- insert into shifts(Shift_TypeID,SHiftSTartTime,ShiftEndTime) values('3','18:00','21:00') -- insert into shifts(Shift_TypeID,SHiftSTartTime,ShiftEndTime) values('4','21:00','9:00') --Select * from Shifts for example time is store in ...