create table T
(
ins_date datetime
)
Insert into T values('2015-10-1')
Insert into T values('2015-10-5')
Insert into T values('2015-10-3')
Insert into T values('2015-10-2 11:00:00')
Insert into T values('2015-10-4 12:10:00')
Insert into T values('2015-10-6 10:11:12')
Select * From T
Select * from T where ins_date<>Convert(VArchar(10),ins_date,121)
--或者
Select * from T where Convert(VArchar(30),ins_date,121) not like '%00:00:00.000'