Return to Answer

edited body

Source Link

edited May 12, 2019 at 10:48

4.6k
17
14

I tried this solution :

WITH recursive Date_Ranges AS (
    select ‘2018'2018-11-30’30' as Date
   union all
   select Date + interval 1 day
   from Date_Ranges
   where Date < ‘2018'2018-12-31’31')
select * from Date_Ranges;

I tried this solution :

WITH recursive Date_Ranges AS (
    select ‘2018-11-30’ as Date
   union all
   select Date + interval 1 day
   from Date_Ranges
   where Date < ‘2018-12-31’)
select * from Date_Ranges;

I tried this solution :

WITH recursive Date_Ranges AS (
    select '2018-11-30' as Date
   union all
   select Date + interval 1 day
   from Date_Ranges
   where Date < '2018-12-31')
select * from Date_Ranges;

Source Link

created Dec 6, 2018 at 10:07

preeti tank

I tried this solution :

WITH recursive Date_Ranges AS (
    select ‘2018-11-30’ as Date
   union all
   select Date + interval 1 day
   from Date_Ranges
   where Date < ‘2018-12-31’)
select * from Date_Ranges;