Oracle 11g Release 2

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

select TO_DATE('JUL 10 2006','MON DD YY', 'NLS_DATE_LANGUAGE = American')
from dual;

TO_DATE('JUL102006','MONDDYY','NLS_DATE_LANGUAGE=AMERICAN')

10-JUL-06

select to_date('2022-02-24', 'YYYY-MM-DD')
  from dual;

TO_DATE('2022-02-24','YYYY-MM-DD')

24-FEB-22

select TO_DATE('中華民國111-02-24','eeyyy-mm-dd'
               , 'NLS_CALENDAR= ''ROC Official''')
  from dual;

TO_DATE('中華民國111-02-24','EEYYY-MM-DD','NLS_CALENDAR=''ROCOFFICIAL''')

24-FEB-22

select to_char(sysdate, 'eeyyy-mm-dd', 'NLS_CALENDAR= ''ROC Official''')
  from dual;

TO_CHAR(SYSDATE,'EEYYY-MM-DD','NLS_CALENDAR=''ROCOFFICIAL''')

中華民國111-02-24