By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| record_id | starttime | endtime | measure | measure |
|---|---|---|---|---|
| 1 | 2020-06-06 09:45:00.000 | 2020-06-06 18:31:00.000 | 682 | 682.000000000000 |
| 2 | 2020-06-06 23:21:00.000 | 2020-06-07 00:00:00.000 | 543 | 30.691304347590 |
| 2 | 2020-06-07 00:00:00.000 | 2020-06-07 10:51:00.000 | 543 | 512.308695651867 |
| 3 | 2020-06-06 16:38:00.000 | 2020-06-07 00:00:00.000 | 20921 | 3742.242816669373 |
| 3 | 2020-06-07 00:00:00.000 | 2020-06-08 00:00:00.000 | 20921 | 12191.922298648227 |
| 3 | 2020-06-08 00:00:00.000 | 2020-06-08 09:49:00.000 | 20921 | 4986.834884661479 |