Use DATEPART Function as a LIKE operator.

SELECT * Your_Table_Name 
where (DATEPART(yy, Your_Column_Name) = 2012
AND DATEPART(mm, Your_Column_Name) ) = 10
AND DATEPART(dd, Your_Column_Name) ) = 18) 
order by Your_Column_Name desc