add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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 早退