By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| id | earliest_date | fromDate | todate | (No column name) | (No column name) |
|---|---|---|---|---|---|
| 1 | 01/09/2019 00:00:00 | 01/09/2019 00:00:00 | 01/09/2019 00:00:00 | 1 | 1 |
| 2 | 01/09/2019 00:00:00 | 02/09/2019 00:00:00 | 03/09/2019 00:00:00 | 2 | 3 |
| 3 | 01/09/2019 00:00:00 | 02/09/2019 00:00:00 | 03/09/2019 00:00:00 | 2 | 3 |
| 4 | 01/09/2019 00:00:00 | 04/09/2019 00:00:00 | 06/09/2019 00:00:00 | 4 | 6 |
| 5 | 01/09/2019 00:00:00 | 07/09/2019 00:00:00 | 07/09/2019 00:00:00 | 7 | 7 |