DECLARE @T AS table (dt datetime NOT NULL INDEX i);
DECLARE @d date = CONVERT(date, '0001-01-01', 23);
INSERT @T (dt) VALUES (CURRENT_TIMESTAMP);
SELECT T.dt FROM @T AS T WHERE T.dt >= @d;
SELECT T.dt FROM @T AS T WHERE T.dt >= CONVERT(datetime, @d);