How to get different distinct dates between the two dates

SELECT  distinct
      colName
  FROM tblName
  where colName between  fromDate and toDate

WITH date_range (calc_date) AS (
    SELECT DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP) - 6, 0)
        UNION ALL SELECT DATEADD(DAY, 1, calc_date)
            FROM date_range
            WHERE DATEADD(DAY, 1, calc_date) < CURRENT_TIMESTAMP)
SELECT calc_date
FROM date_range;

Where [date_TO_BE_COMPARED] BETWEEN from_date AND to_date

WITH cteDateList AS

 (

     SELECT CAST('2012-01-01' AS DATETIME) DateValue

     UNION ALL

     SELECT DateValue + 1

     FROM    cteDateList

     WHERE   DateValue + 1 < '2013-01-01'

 )

 SELECT DateValue

 FROM    cteDateList

 OPTION (MAXRECURSION 0)