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.
id status timestamp
1 logout 2021-01-01 05:01:00
2 login 2021-01-01 06:02:00
3 online 2021-01-01 06:03:00
4 away 2021-01-01 06:04:00
5 online 2021-01-01 06:05:00
6 logout 2021-01-02 04:00:00
7 login 2021-01-02 04:05:00
8 online 2021-01-02 04:07:00
9 away 2021-01-02 04:08:00
10 break 2021-01-02 04:10:00
11 online 2021-01-02 04:15:00
12 logout 2021-01-02 04:55:00
13 login 2021-01-02 05:04:00
14 online 2021-01-02 05:05:00
15 away 2021-01-03 05:01:00
16 logout 2021-01-03 05:02:00
17 login 2021-01-03 05:04:00
18 online 2021-01-03 05:05:00
19 logout 2021-01-04 03:05:00
id status timestamp
1 logout 2021-01-01 05:01:00
2 login 2021-01-01 06:02:00
3 online 2021-01-01 06:03:00
5 online 2021-01-01 06:05:00
6 logout 2021-01-02 04:00:00
7 login 2021-01-02 04:05:00
8 online 2021-01-02 04:07:00
11 online 2021-01-02 04:15:00
12 logout 2021-01-02 04:55:00
13 login 2021-01-02 05:04:00
14 online 2021-01-02 05:05:00
16 logout 2021-01-03 05:02:00
17 login 2021-01-03 05:04:00
18 online 2021-01-03 05:05:00
19 logout 2021-01-04 03:05:00
login online logout
2021-01-01 06:02:00 2021-01-01 06:03:00 2021-01-02 04:00:00
2021-01-02 04:05:00 2021-01-02 04:07:00 2021-01-02 04:55:00
2021-01-03 05:04:00 2021-01-03 05:05:00 2021-01-04 03:05:00
date login online logout
2021-01-01 2021-01-02 04:05:00 2021-01-02 04:07:00 2021-01-02 04:55:00
2021-01-02 2021-01-02 05:04:00 2021-01-02 05:05:00 2021-01-03 05:02:00
2021-01-03 2021-01-03 05:04:00 2021-01-03 05:05:00 2021-01-04 03:05:00
date online logout
2021-01-01 2021-01-02 04:07:00 2021-01-02 04:55:00
2021-01-02 2021-01-02 05:05:00 2021-01-03 04:59:59
2021-01-03 2021-01-03 05:05:00 2021-01-04 03:05:00