To Get Accurate Records between two dates from the Table of MS SQL SERVER.
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)