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.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
Local_Datetime Machine State Duration State_Text State_Date State_Time Prev_State Prev_State_Text Prev_State_Datestamp Next_State Next_State_Text Next_State_Datestamp
2023-06-01 00:00:00.000 PC1 0 300 Idle 2023-06-01 00:00:00.0000000 null null null 1 Active 2023-06-01 00:05:00.000
2023-06-01 00:05:00.000 PC1 1 600 Active 2023-06-01 00:05:00.0000000 0 Idle 2023-06-01 00:00:00.000 0 Idle 2023-06-01 00:15:00.000
2023-06-01 00:15:00.000 PC1 0 373500 Idle 2023-06-01 00:15:00.0000000 1 Active 2023-06-01 00:05:00.000 1 Active 2023-06-05 08:00:00.000
2023-06-05 08:00:00.000 PC1 1 600 Active 2023-06-05 08:00:00.0000000 0 Idle 2023-06-01 00:15:00.000 0 Idle 2023-06-05 08:10:00.000
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
Local_Datetime Machine State Duration State_Text State_Date State_Time Prev_State Prev_State_Text Prev_State_Datestamp Next_State Next_State_Text Next_State_Datestamp
2023-06-01 00:00:00.000 PC1 0 300 Idle 2023-06-01 00:00:00.0000000 null null null 1 Active 2023-06-01 00:05:00.000
2023-06-01 00:05:00.000 PC1 1 600 Active 2023-06-01 00:05:00.0000000 0 Idle 2023-06-01 00:00:00.000 0 Idle 2023-06-01 00:15:00.000
2023-06-01 00:15:00.000 PC1 0 85500 Idle 2023-06-01 00:15:00.0000000 1 Active 2023-06-01 00:05:00.000 0 Idle 2023-06-02 00:00:00.000
2023-06-02 00:00:00.000 PC1 0 86400 Idle 2023-06-02 00:00:00.0000000 0 Idle 2023-06-01 00:15:00.000 0 Idle 2023-06-03 00:00:00.000
2023-06-03 00:00:00.000 PC1 0 86400 Idle 2023-06-03 00:00:00.0000000 0 Idle 2023-06-02 00:00:00.000 0 Idle 2023-06-04 00:00:00.000
2023-06-04 00:00:00.000 PC1 0 86400 Idle 2023-06-04 00:00:00.0000000 0 Idle 2023-06-03 00:00:00.000 0 Idle 2023-06-05 00:00:00.000
2023-06-05 00:00:00.000 PC1 0 28800 Idle 2023-06-05 00:00:00.0000000 0 Idle 2023-06-04 00:00:00.000 1 Active 2023-06-05 08:00:00.000
2023-06-05 08:00:00.000 PC1 1 600 Active 2023-06-05 08:00:00.0000000 0 Idle 2023-06-01 00:15:00.000 0 Idle 2023-06-05 08:10:00.000