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'));