By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 6 Duplicates: 0 Warnings: 0
| Employee | Date_Time | Date_Time_In | DateTime_Out |
|---|---|---|---|
| std001 | 2024-02-01 | 2024-02-01 22:01:00 | 2024-02-02 06:00:05 |
| std001 | 2024-02-02 | null | 2024-02-02 06:00:05 |
| std001 | 2024-02-03 | 2024-02-03 07:59:00 | 2024-02-03 17:00:00 |
| std001 | 2024-02-04 | 2024-02-04 06:00:00 | 2024-02-04 14:00:00 |