I pass a date into my stored procedure as '05/31/2001' and want pull all records whos datetime field match that date. It seems the time portion of my datetime field causes the comparison not to match.

Should I be using something like the datepart function and comparing the month, day and year or is there a better way.

Thanks,

Chris