add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
NAME JOB START_TIME STOP_TIME OVERLAP_FLAG
JOE A02 2020-08-18 09:22:31 2020-08-18 15:59:12 Y
JOE A01 2020-08-18 09:22:35 2020-08-18 15:58:55 Y
JOE B01 2020-08-18 09:22:43 2020-08-18 15:58:32 Y
JOE B02 2020-08-18 09:22:49 2020-08-18 15:58:45 Y
JOE C02 2020-08-18 09:22:56 2020-08-18 15:58:20 Y
JOE C01 2020-08-18 09:23:04 2020-08-18 15:58:08 Y
JOE X01 2020-08-18 15:57:02 2020-08-18 15:57:03 Y
JOE Y01 2020-08-18 15:57:11 2020-08-18 15:57:12 Y
JOE Z01 2020-08-18 15:57:30 2020-08-18 15:57:31 Y
JOE W01 2020-08-18 15:57:47 2020-08-18 15:57:48 Y
NAME JOB START_TIME STOP_TIME OVERLAP_FLAG NEW_OVERLAP_FLAG
JOE A02 2020-08-18 09:22:31 2020-08-18 15:59:12 Y Y
JOE A01 2020-08-18 09:22:35 2020-08-18 15:58:55 Y Y
JOE B01 2020-08-18 09:22:43 2020-08-18 15:58:32 Y Y
JOE B02 2020-08-18 09:22:49 2020-08-18 15:58:45 Y Y
JOE C02 2020-08-18 09:22:56 2020-08-18 15:58:20 Y Y
JOE C01 2020-08-18 09:23:04 2020-08-18 15:58:08 Y Y
JOE X01 2020-08-18 15:57:02 2020-08-18 15:57:03 Y Y
JOE Y01 2020-08-18 15:57:11 2020-08-18 15:57:12 Y Y
JOE Z01 2020-08-18 15:57:30 2020-08-18 15:57:31 Y Y
JOE W01 2020-08-18 15:57:47 2020-08-18 15:57:48 Y Y