MySQL 8.0

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

CREATE TABLE table1
    (`YEAR` int, `MONTH` int, `DAY` int, `VALUE` int)
INSERT INTO table1
    (`YEAR`, `MONTH`, `DAY`, `VALUE`)
VALUES
    (2018, 11, 9, 1056),
    (2018, 11, 10, 6582),
    (2018, 12, 9, 6892),
    (2018, 12, 10, 5987),
    (2019, 3, 5, 5693),
    (2019, 3, 6, 5698)

Records: 6  Duplicates: 0  Warnings: 0


SELECT *
FROM table1
WHERE STR_TO_DATE(CONCAT_WS('/', `DAY`, `MONTH`, `YEAR`), '%d/%m/%Y') BETWEEN '2018-11-09' AND '2019-03-05'


YEAR
MONTH
DAY
VALUE


2018
11
9
1056

2018
11
10
6582

2018
12
9
6892

2018
12
10
5987

2019
3
5
5693