select orderid from orders where Convert(char(10),orderdate,112) = '19960829'gives this...
SELECT [Id] FROM [MyTable] WHERE CONVERT(CHAR(10),DateField,112) = @DateFieldCode 112 in convert means ISO, but you can use 110 for USA mm-dd-yy, see BOL.
>SELECT [Id] >FROM [MyTable] >WHERE YEAR(DateField) = YEAR(@DateField) AND > MONTH(DateField) = MONTH(@DateField) AND > DAY(DateField) = DAY(@DateField) >>