>This table has a datetime column that contains times in it as well as the date. >I want to locate all records with a specific date, ignoring the time >I can see how to do it with dateparts, etc but that seems tacky >What's the most efficent way?
The most efficient and simplest way is to use
where DateTimeField >=@StartDate and DateTimeField < @EndDate -- which is one day later