Why can not I enter this date in a table using sql?

advertisements

Structure of the employee table:

 Name          Null?    Type
 ------------- -------- ------------
 EMPLOYEE_ID   NOT NULL NUMBER(38)
 FIRST_NAME             VARCHAR2(50)
 LAST_NAME              VARCHAR2(50)
 EMAIL                  VARCHAR2(50)
 DEPT_ID                NUMBER(38)
 SALARY                 NUMBER(38)
 COMMISION_PCT          FLOAT(126)
 HIREDATE               DATE

INSERT statement :

insert into employees_table
values (05,'Sophie','Kuchinskey','[email protected]',105,5000000,60,'20-sept-1994');

ERROR at line 1: ORA-01841: (full) year must be between -4713 and +9999, and not be 0


Please convert the date into correct date format

insert into employees_table values(05,'Sophie','Kuchinskey','[email protected]',105,5000000,60,to_date('20-sep-1994','dd-Mon-YYYY'));

Also you can't give month as sept . it should be sep.