MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE elbat
             (date datetime,
              value integer);
INSERT INTO elbat
            (date,
             value)
            VALUES
('2019-09-18 11:54:10',         0),
('2019-09-18 11:52:58',         0),
('2019-09-18 11:48:39',         0),
('2019-09-18 11:24:28',         1),
('2019-09-18 11:23:05',         1),
('2019-09-17 13:01:25',         1),
('2019-09-17 12:57:56',         0),
('2019-08-29 15:32:43',         0),
('2019-08-29 15:29:59',         2),
('2019-03-20 11:42:09',         2),
('2019-03-20 11:37:32',         1),
('2019-01-25 11:05:18',         0);
SELECT t1.date,
       t1.value
       FROM elbat t1
       WHERE t1.value <> (SELECT t2.value
                                 FROM elbat t2
                                 WHERE t2.date < t1.date
                                 ORDER BY t2.date DESC
                                 LIMIT 1);


date
value


2019-09-18 11:48:39
0

2019-09-17 13:01:25
1

2019-08-29 15:32:43
0

2019-03-20 11:42:09
2

2019-03-20 11:37:32
1

date	value
2019-09-18 11:48:39	0
2019-09-17 13:01:25	1
2019-08-29 15:32:43	0
2019-03-20 11:42:09	2
2019-03-20 11:37:32	1