By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| EmpId | INTIME | OUTIME |
|---|---|---|
| 1 | 21/05/2018 08:44:00 | 21/05/2018 10:44:00 |
| 1 | 26/05/2018 08:44:00 | 26/05/2018 08:44:00 |
| 2 | 23/05/2018 08:44:00 | 23/05/2018 08:44:00 |
| 2 | 28/05/2018 08:44:00 | 28/05/2018 12:44:00 |
| 2 | null | 01/06/2018 08:00:00 |