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.
CREATE TABLE dt (
`ID` VARCHAR(7),
`GROUP` VARCHAR(2),
`TIMESTAMP1` VARCHAR(23),
`col_OTHER` VARCHAR(7),
`TIMESTAMP2` VARCHAR(23)
);

INSERT INTO dt
(`ID`, `GROUP`, `TIMESTAMP1`, `col_OTHER`, `TIMESTAMP2`)
VALUES
('001', 'AA', '2021-04-02 15:02:33.319', 'mangos', null),
('002', 'BB', null, 'kiwis', null),
('004', 'AA', '2021-04-02 03:51:35.279', 'oranges', null),
('003', 'DD', '2021-04-03 18:24:23.469', 'oranges', '2021-04-03 18:22:23.469'),
('003', 'DD', null, 'bananas', '2021-04-03 15:02:33.319'),
('002', 'CC', '2021-04-04 11:02:51.313', 'apples', '2021-04-04 11:03:51.313');
SELECT *
FROM dt
WHERE COALESCE(TIMESTAMP1, '1970-01-01') < '2021-04-03'
OR COALESCE(TIMESTAMP1, '1970-01-01') < TIMESTAMP2
ID GROUP TIMESTAMP1 col_OTHER TIMESTAMP2
001 AA 2021-04-02 15:02:33.319 mangos null
002 BB null kiwis null
004 AA 2021-04-02 03:51:35.279 oranges null
003 DD null bananas 2021-04-03 15:02:33.319
002 CC 2021-04-04 11:02:51.313 apples 2021-04-04 11:03:51.313
SELECT *
FROM dt
WHERE COALESCE(TIMESTAMP1, '1970-01-01') < COALESCE(TIMESTAMP2, '2021-04-03')
ID GROUP TIMESTAMP1 col_OTHER TIMESTAMP2
001 AA 2021-04-02 15:02:33.319 mangos null
002 BB null kiwis null
004 AA 2021-04-02 03:51:35.279 oranges null
003 DD null bananas 2021-04-03 15:02:33.319
002 CC 2021-04-04 11:02:51.313 apples 2021-04-04 11:03:51.313