By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Person | Begining | Ending | Length | Bucket |
---|---|---|---|---|
1 | 2022-01-01 12:25:00.000 | 2022-01-01 13:05:00.000 | 300 | 12:15 |
1 | 2022-01-01 12:25:00.000 | 2022-01-01 13:05:00.000 | 900 | 12:30 |
1 | 2022-01-01 12:25:00.000 | 2022-01-01 13:05:00.000 | 900 | 12:45 |
1 | 2022-01-01 12:25:00.000 | 2022-01-01 13:05:00.000 | 300 | 13:00 |