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 |