date sql server to date oracle format code example

Example 1: oracle to date

SELECT
  TO_DATE( '5 Jan 2017', 'DD MON YYYY' )
FROM
  dual;

---or----
INSERT INTO members(first_name, last_name, joined_date)
VALUES('Laureen','Davidson', TO_DATE('Feb 01 2017','Mon DD YYYY'));

Example 2: specific date format oracle

TO_CHAR (TO_DATE('0297','MM/YY'), 'MM/YY')