By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| event_id | start_time | end_time | real_end_time |
|---|---|---|---|
| 1001 | 2021-02-21 14:00:00.000 | 2021-02-21 18:00:00.000 | 2021-02-21 18:00:00.000 |
| 1002 | 2021-02-21 17:00:00.000 | 2021-02-22 00:00:00.000 | 2021-02-22 03:00:00.000 |
| 1002 | 2021-02-22 00:00:00.000 | 2021-02-22 03:00:00.000 | 2021-02-22 03:00:00.000 |
| 1003 | 2021-02-21 18:00:00.000 | 2021-02-21 22:00:00.000 | 2021-02-21 22:00:00.000 |
| 1004 | 2021-02-21 22:00:00.000 | 2021-02-22 00:00:00.000 | 2021-02-22 07:00:00.000 |
| 1004 | 2021-02-22 00:00:00.000 | 2021-02-22 07:00:00.000 | 2021-02-22 07:00:00.000 |