I have a table [T] with columns id
,start_date
, end_date
. I want to get id
, date
, where id is split into multiple dates using start date and end date.
For example:
Input:
id | start_date | end_date |
---|---|---|
1 | 2022-04-03 | 2022-04-07 |
2 | 2022-04-11 | 2022-04-11 |
Expected Output
id | date |
---|---|
1 | 2022-04-03 |
1 | 2022-04-04 |
1 | 2022-04-05 |
1 | 2022-04-06 |
1 | 2022-04-07 |
2 | 2022-04-11 |