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)
Getting Accurate Records between two dates from the Table of MS SQL SERVER
AND
convert(nvarchar,dateColumn,112)<=convert(nvarchar,toDate,112)
Join the conversation! Your thoughts help the community grow.