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