if a column in DB table is a datetime and you need to compare TIME only (without DATE) , there is no built in function for that.

Here is small Query to perform that task. The key is converting both to same Date
@time1 datetime
@time2 datetime
select @time1 = ‘1900-01-01 07:30:00.000′,
@time2 = ‘1899-12-30 07:30:00.000′
– This convert both @time1 & @time2 into same date (1900-01-01)
– Note : Resuls is a datetime
select tm1 = dateadd(day, datediff(day, 0, @time1) * -1, @time1),
– This uses convert function + substring to extract the time.
– Note : Result will be a varchar
tm2 = dateadd(day, datediff(day, 0, @time2) * -1, @time2)
select tm1 = substring(convert(varchar(25), @time1, 121), 12, 12),
tm2 = substring(convert(varchar(25), @time2, 121), 12, 12)