By using following query we will get desired results

SELECT * FROM myTable WHERE convert(nvarchar,dateColumn,112)>=convert(nvarchar,fromDate,112)
AND
convert(nvarchar,dateColumn,112)<=convert(nvarchar,toDate,112)