MySQL 8.0

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

select version();

version()

8.0.36

CREATE TABLE foo (bar DATE);
SELECT @@SESSION.sql_mode;

@@SESSION.sql_mode

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

INSERT INTO foo (bar) VALUES ('2019-02-30');

Incorrect date value: '2019-02-30' for column 'bar' at row 1

SET @@SESSION.sql_mode = CONCAT_WS(',', @@SESSION.sql_mode, 'ALLOW_INVALID_DATES');
INSERT INTO foo (bar) VALUES ('2019-02-30');
SELECT * FROM foo;

bar

2019-02-30