SELECT [Id] FROM [MyTable] WHERE YEAR(DateField) = YEAR(@DateField) AND MONTH(DateField) = MONTH(@DateField) AND DAY(DateField) = DAY(@DateField)I want to select the records that have the same date as the parameter, but I do not care about the time part of the field or parameter.