By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select TO_DATE('2022.02.21','YYYY-MM-DD') from dual;
| TO_DATE('2022.02.21','YYYY-MM-DD') |
|---|
| 21-FEB-22 |
select TO_DATE('20220221','YYYY-MM-DD') from dual;
| TO_DATE('20220221','YYYY-MM-DD') |
|---|
| 21-FEB-22 |
select TO_DATE('2022/02/21','YYYY-MM-DD') from dual;
| TO_DATE('2022/02/21','YYYY-MM-DD') |
|---|
| 21-FEB-22 |
select TO_DATE('2022.02.21','fxYYYY-MM-DD') from dual;
ORA-01861: literal does not match format string
select TO_DATE('20220221','fxYYYY-MM-DD') from dual;
ORA-01861: literal does not match format string
select TO_DATE('2022/02/21','fxYYYY-MM-DD') from dual;
ORA-01861: literal does not match format string
select TO_DATE('2022-02-21','fxYYYY-MM-DD') from dual;
| TO_DATE('2022-02-21','FXYYYY-MM-DD') |
|---|
| 21-FEB-22 |