This should work. Make a simple test:

Create table DateTest (OnlyDate datetime)

GO

select * from datetest

insert into DateTest (onlydate)

Select '20060102' -- Format your date as YYYYMMDD as mentioned before

select * from...