Oracle 18c

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

SELECT TO_DATE
    ('2/2/2021 8:08:58 PM','MM/DD/YYYY HH:MI:SS AM') "NOW"
     FROM DUAL;


NOW


02-FEB-21


alter session set nls_language = 'CZECH'
SELECT TO_DATE
    ('2/2/2021 8:08:58 PM','MM/DD/YYYY HH:MI:SS AM') "NOW"
     FROM DUAL;
ORA-01855: požaduje se AM/A.M. nebo PM/P.M.

alter session set nls_language = 'ENGLISH'
alter session set nls_date_language = 'CZECH'
SELECT TO_DATE
    ('2/2/2021 8:08:58 PM','MM/DD/YYYY HH:MI:SS AM') "NOW"
     FROM DUAL;
ORA-01855: AM/A.M. or PM/P.M. required

SELECT TO_DATE
    ('2/2/2021 8:08:58 ODPOLEDNE','MM/DD/YYYY HH:MI:SS AM') "NOW"
     FROM DUAL;


NOW


02-ÚNO-21


SELECT TO_DATE
    ('2/2/2021 8:08:58 PM','MM/DD/YYYY HH:MI:SS AM','NLS_DATE_LANGUAGE=ENGLISH') "NOW"
     FROM DUAL;


NOW


02-ÚNO-21