.net - How to use Where clause with datetime in SQL Server 2008 -

i have written query:

select *  w_tbl  did not in (select did tbl_assign)    , cast(measdatetime date) = @dta  order      cast(measdatetime date) desc 

so can see sending parametrized query.

so put 24/09/2010 00:00:00 @dta

but error:

conversion failed when converting date and/or time charterer string.

i tell why doing , purpose:

i have datetime column, , want select/fetch data date (i.e. don't want fetch datetime wise, has according date)

if want select date , have datetime type, use date functions:

dateadd ( dd , 0 , datediff ( dd , 0 , @dta)) 

so in case:

select *  w_tbl  did not in (select did tbl_assign)    , dateadd ( dd , 0 , datediff ( dd , 0 , measdatetime)) = dateadd ( dd , 0 , datediff ( dd , 0 , @dta))  order      measdatetime desc -- no need cast/convert here, ok either way