HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlModerate

Generate Dates between Date Ranges in mysql

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
datesdaterangesgeneratebetweenmysql

Problem

Is there a way to generate dates between date ranges. After looking on SO I found out there is a way to use CTE, another option is to use Union All from 0 to 9.
Is there an inbuilt function which I can use to generate dates between date range?

We are using MySQL 8.0.

Solution

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;

Code Snippets

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;

Context

StackExchange Database Administrators Q#224182, answer score: 18

Revisions (0)

No revisions yet.