By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
DeviceName | StartDate | EndDate | DiffSeconds |
---|---|---|---|
reg | 12/09/2018 11:36:40 | 12/09/2018 11:38:52 | 132 |
reg | 12/09/2018 12:03:18 | 12/09/2018 12:03:25 | 7 |
reg | 12/09/2018 14:46:09 | 12/09/2018 14:46:18 | 9 |