Hi ,
Try This Query..
SELECT Column_Name
FROM Table_Name
WHERE CONVERT(VARCHAR(10),(CAST(YEAR_Column AS VARCHAR(4))+'-'+CAST(Month_Column AS VARCHAR(4))+'-'+CAST(Day_Column AS VARCHAR(4))), 112)
BETWEEN CONVERT(VARCHAR(10),From_Date, 112) AND CONVERT(VARCHAR(10),To_Date, 112)
GVPrabu