By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| t | agent | conn | disconn | duration | date_part |
|---|---|---|---|---|---|
| 2019-03-18 12:00:00 | 20024 | 2019-03-18 12:01:00 | 2019-03-18 13:01:30 | 3630 | 840 |
| 2019-03-18 12:15:00 | 20024 | 2019-03-18 12:01:00 | 2019-03-18 13:01:30 | 3630 | 900 |
| 2019-03-18 12:30:00 | 20024 | 2019-03-18 12:01:00 | 2019-03-18 13:01:30 | 3630 | 900 |
| 2019-03-18 12:45:00 | 20024 | 2019-03-18 12:01:00 | 2019-03-18 13:01:30 | 3630 | 900 |
| 2019-03-18 13:00:00 | 20024 | 2019-03-18 12:01:00 | 2019-03-18 13:01:30 | 3630 | 90 |
| 2019-03-11 08:45:00 | 20011 | 2019-03-11 08:47:40 | 2019-03-11 09:30:10 | 2550 | 740 |
| 2019-03-11 09:00:00 | 20011 | 2019-03-11 08:47:40 | 2019-03-11 09:30:10 | 2550 | 900 |
| 2019-03-11 09:15:00 | 20011 | 2019-03-11 08:47:40 | 2019-03-11 09:30:10 | 2550 | 900 |
| 2019-03-11 09:30:00 | 20011 | 2019-03-11 08:47:40 | 2019-03-11 09:30:10 | 2550 | 10 |
SELECT 9