Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
alter session set nls_date_format = 'DD/MM/YYYY'
SELECT 
    CASE WHEN (DATE '2005-11-25') IN ('25/11/05') THEN
        'TRUE'
    ELSE
        'FALSE'
    END
FROM DUAL;


CASEWHEN(DATE'2005-11-25')IN('25/11/05')THEN'TRUE'ELSE'FALSE'END


FALSE


alter session set nls_date_format = 'DD/MM/YY'
SELECT 
    CASE WHEN (DATE '2005-11-25') IN ('25/11/05') THEN
        'TRUE'
    ELSE
        'FALSE'
    END
FROM DUAL;


CASEWHEN(DATE'2005-11-25')IN('25/11/05')THEN'TRUE'ELSE'FALSE'END


TRUE


alter session set nls_date_format = 'DD/MM/RR'
SELECT 
    CASE WHEN (DATE '2005-11-25') IN ('25/11/05') THEN
        'TRUE'
    ELSE
        'FALSE'
    END
FROM DUAL;


CASEWHEN(DATE'2005-11-25')IN('25/11/05')THEN'TRUE'ELSE'FALSE'END


TRUE


alter session set nls_date_format = 'DD/MM/RRRR'
SELECT 
    CASE WHEN (DATE '2005-11-25') IN ('25/11/05') THEN
        'TRUE'
    ELSE
        'FALSE'
    END
FROM DUAL;


CASEWHEN(DATE'2005-11-25')IN('25/11/05')THEN'TRUE'ELSE'FALSE'END


TRUE