oracle sysdate format code example
Example 1: oracle default date format
SELECT
TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
dual;
Example 2: date format in oracle
e.g., 01-JAN-17
SELECT
TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
dual;
e.g., 01-JAN-17