By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
empno | attendanttype | recorddatetime |
---|---|---|
000130 | 1 | 2023-07-12 03:55:04.000 |
000130 | 1 | 2023-07-12 03:55:06.000 |
000130 | 2 | 2023-07-12 05:01:04.000 |
000130 | 2 | 2023-07-12 05:05:04.000 |
000130 | 1 | 2023-07-12 06:55:04.000 |
000131 | 2 | 2023-07-12 03:55:07.000 |
000131 | 2 | 2023-07-12 03:55:05.000 |
000132 | 1 | 2023-07-12 04:55:04.000 |
000132 | 1 | 2023-07-12 04:55:08.000 |
000133 | 2 | 2023-07-12 04:55:04.000 |
000133 | 2 | 2023-07-12 07:55:08.000 |
No_P | Start_P | End_P |
---|---|---|
1 | 00:00:00 | 04:00:00 |
2 | 04:00:00 | 05:00:00 |
3 | 05:00:00 | 07:00:00 |
4 | 07:00:00 | 08:00:00 |
5 | 08:00:00 | 12:00:00 |
empno | attendanttype | recorddatetime | No_P | No | Date_X | Time_X | Status |
---|---|---|---|---|---|---|---|
000130 | 1 | 2023-07-12 03:55:04.000 | 1 | 1 | 2023/07/12 | 03:55:04 | 準時上班 |
000130 | 1 | 2023-07-12 06:55:04.000 | 3 | 1 | 2023/07/12 | 06:55:04 | 準時上班 |
000132 | 1 | 2023-07-12 04:55:04.000 | 2 | 1 | 2023/07/12 | 04:55:04 | 遲到 |
empno | attendanttype | recorddatetime | No_P | No | Date_X | Time_X | Status |
---|---|---|---|---|---|---|---|
000130 | 2 | 2023-07-12 05:01:04.000 | 3 | 1 | 2023/07/12 | 05:01:04 | 準時下班 |
000131 | 2 | 2023-07-12 03:55:05.000 | 1 | 1 | 2023/07/12 | 03:55:05 | 準時下班 |
000133 | 2 | 2023-07-12 04:55:04.000 | 2 | 1 | 2023/07/12 | 04:55:04 | 早退 |
000133 | 2 | 2023-07-12 07:55:08.000 | 4 | 1 | 2023/07/12 | 07:55:08 | 早退 |