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.
6 rows affected
ITEMID
2
1
ITEMID
2
1
ITEMID
1
2
3 rows affected
ITEMID
2
1
ITEMID VALIDFROM VALIDTO MATCH
1 2024-01-01 00:00:00 2024-01-02 23:59:59 null
1 2024-01-04 00:00:00 2024-01-10 23:59:59 null
1 2024-01-15 00:00:00 null null
2 2023-12-30 00:00:00 2024-01-02 23:59:59 null
3 2023-12-31 00:00:00 null 1
4 2023-12-30 00:00:00 2024-01-03 23:59:59 1
5 2024-01-03 01:00:00 2024-01-03 02:00:00 null
6 2024-01-02 00:00:00 2024-01-03 01:59:59 null
6 2024-01-03 02:00:00 2024-01-03 23:59:59 null
ITEMID
6
2
5
1
ITEMID VALIDFROM VALIDTO
1 2024-01-01 00:00:00 2024-01-02 23:59:59
1 2024-01-04 00:00:00 2024-01-10 23:59:59
1 2024-01-15 00:00:00 null
2 2023-12-30 00:00:00 2024-01-02 23:59:59
3 2023-12-31 00:00:00 null
4 2023-12-30 00:00:00 2024-01-03 23:59:59
5 2024-01-03 01:00:00 2024-01-03 02:00:00
6 2024-01-02 00:00:00 2024-01-03 23:59:59
ITEMID
1
2
5