By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 1
| id | ts | dateto | duration_ |
|---|---|---|---|
| 1 | 2023-02-15 12:45:10 | 2023-02-15 13:59:59 | 01:14:49 |
| 1 | 2023-02-15 12:45:10 | 2023-02-20 11:59:59 | 2 days 23:14:49 |
| 1 | 2023-02-15 12:45:10 | 2023-02-28 23:59:59 | 9 days 11:14:49 |
SELECT 3