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
Chris