[Solved] Compare Time part of DateTime Field in SQL Server

Other way:

DECLARE @temp TABLE (DepartmentID INT, [DateTime] DateTime, EmpID INT)
 
INSERT INTO  @temp VALUES(58, '2015-01-01 20:00:00', 1111)
INSERT INTO  @temp VALUES(58, '2015-01-12 01:00:00', 4444)
INSERT INTO  @temp VALUES(47, '2015-04-12 16:00:00', 5555)
INSERT INTO  @temp VALUES(58, '2015-01-19 03:00:00', 963)
INSERT INTO  @temp VALUES(58, '2015-01-19 14:00:00', 4555)
 

SELECT *
FROM @temp
Where DepartmentID=58 And
CAST(DateTime as Time) >= '08:00 PM' 
or CAST(DateTime as Time) <= '06:00 AM'

It Might Help !!