oracle sql to_date format code example

Example: oracle to_date

SELECT
  TO_DATE( '21 12 2017', 'DD MM YYYY' )
FROM
  dual;

---or----
INSERT INTO members(first_name, last_name, joined_date)
VALUES('Laureen','Davidson', TO_DATE('2017/12/21','YYYY/MM/DD'));