oracle default date format code example Example: oracle default date format SELECT TO_DATE( '24-JUL-21', 'DD-MON-RR' ) FROM dual;