I am trying to fetch all records created after or equal to a specific record create date. I am using following query but it is not giving me correct results .I am only interested in compareing dates till hours and not beyond that.
Please let me know how should I rewrite query to get desired result
From Master tm
tm.CreateDate >= (Select CreateDate From Master Where MasterID = @MasterId)