CODE EXAMPLE FOR SQL

oracle default date format

SELECT
  TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
  dual;