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 |