By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
CompLast_SignON_datetime | comp_accidentdate_time | Duty_hours |
---|---|---|
2021-12-16 04:08 | 2021-12-16 05:10 | 01:02 |
2021-12-17 14:20 | 2021-12-17 20:00 | 06:40 |
2021-12-18 12:15 | 2021-12-18 15:25 | 03:10 |
2021-12-22 06:00 | 2021-12-22 12:34 | 06:34 |
2021-12-25 11:30 | 2021-12-25 21:40 | 10:10 |
2021-12-26 21:00 | 2021-12-27 02:50 | 05:50 |
CompLast_SignON_datetime | comp_accidentdate_time | Duty_hours |
---|---|---|
2021-12-16 04:08 | 2021-12-16 05:10 | 01:02 |
2021-12-17 14:20 | 2021-12-17 20:00 | 05:40 |
2021-12-18 12:15 | 2021-12-18 15:25 | 03:10 |
2021-12-22 06:00 | 2021-12-22 12:34 | 06:34 |
2021-12-25 11:30 | 2021-12-25 21:40 | 10:10 |
2021-12-26 21:00 | 2021-12-27 02:50 | 05:50 |
CompLast_SignON_datetime | comp_accidentdate_time | Duty_hours |
---|---|---|
2021-12-16 04:08 | 2021-12-16 05:10 | 1.02 |
2021-12-17 14:20 | 2021-12-17 20:00 | 6.40 |
2021-12-18 12:15 | 2021-12-18 15:25 | 3.10 |
2021-12-22 06:00 | 2021-12-22 12:34 | 6.34 |
2021-12-25 11:30 | 2021-12-25 21:40 | 10.10 |
2021-12-26 21:00 | 2021-12-27 02:50 | 5.50 |