By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | json_field |
|---|---|
| 1 | {"monday": [{"end": "18:00:00", "start": "09:00:00"}, {"end": "21:00:00", "start": "19:00:01"}], "sunday": [{"end": "15:00:00", "start": "14:00:00"}], "saturday": [{"end": "18:00:00", "start": "09:00:00"}]} |
| date_start | date_end | day |
|---|---|---|
| 09:00:00 | 18:00:00 | null |
| 19:00:01 | 21:00:00 | null |
| 14:00:00 | 15:00:00 | null |
| 09:00:00 | 18:00:00 | null |