By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| hour | run | stop | walk |
|---|---|---|---|
| 2021-09-01 09:00:00 | 30 | 15 | 15 |
| 2021-09-01 10:00:00 | 60 | 0 | 0 |
| 2021-09-01 11:00:00 | 45 | 15 | 0 |
| 2021-09-01 12:00:00 | 0 | 30 | 30 |
3 rows affected
| hour | run | stop | walk |
|---|---|---|---|
| 2021-09-01 09:00:00 | 30 | 15 | 15 |
| 2021-09-01 10:00:00 | 60 | 0 | 0 |
| 2021-09-01 11:00:00 | 45 | 15 | 0 |
| 2021-09-01 12:00:00 | 0 | 30 | 30 |