By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
6 rows affected
employee | date | time | Action | OutTime |
---|---|---|---|---|
Leeann Adel Urban | 01/10/2018 00:00:00 | 07:43:00 | ENTRY | null |
Leeann Adel Urban | 01/10/2018 00:00:00 | 12:00:00 | EXIT | null |
Leeann Adel Urban | 01/10/2018 00:00:00 | 12:59:00 | ENTRY | 59 |
Leeann Adel Urban | 01/10/2018 00:00:00 | 16:32:00 | EXIT | null |
Leeann Adel Urban | 02/10/2018 00:00:00 | 07:42:00 | ENTRY | null |
Leeann Adel Urban | 02/10/2018 00:00:00 | 16:33:00 | EXIT | null |