MySQL 8.0

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

create table test (
datecol date)
insert into test (datecol) values ('2022-10-16')
insert into test (datecol) values ('20221016')
insert into test (datecol) values (str_to_date('10/16/2022','%m/%d/%Y"'))
select * from test


datecol


2022-10-16

2022-10-16

2022-10-16


insert into test (datecol) values ('10/16/2022')
Incorrect date value: '10/16/2022' for column 'datecol' at row 1