>Is your 'something' a declared datetime or date datatype, or is it a string being implicitly converted?

It is parameterized into a Date type.

For example:

DECLARE @AddDate DateTime

SET @AddDate='2011-02-01 00:00:00'

DELETE FROM Hit WHERE AddDate<@AddDate