By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| code | place | startdate | enddate |
|---|---|---|---|
| A | Place 1 | 1900-01-01 | 2019-03-15 |
| A | Place 2 | 2019-10-01 | 2022-07-12 |
| A | Place 3 | 2023-01-01 | 3000-01-01 |
4 rows affected
| code | place | startdate | enddate |
|---|---|---|---|
| A | Place 1 | 1900-01-01 | 2019-03-15 |
| A | Place 2 | 2019-10-01 | 2022-07-12 |
| A | Place 3 | 2023-01-01 | 3000-01-01 |