HIREDATE
DATE
SQL> insert into test.emp(ENAME,JOB,MGR,HIREDATE,SAL)
2 values ('shilei','database',1480,'07-01-1995',1480);
values ('shilei','database',1480,'07-01-1995',1480)
*
ERROR 位于第 2 行:
ORA-01843: 无效的月份
SQL> c/01/jul/
2*values ('shilei','database',1480,'07-jul-1995',1480)
SQL> run
1insert into test.emp(ENAME,JOB,MGR,HIREDATE,SAL)
2*values ('shilei','database',1480,'07-jul-1995',1480)
values ('shilei','database',1480,'07-jul-1995',1480)
*
ERROR 位于第 2 行:
ORA-01843: 无效的月份
到底应该怎么写这个格式
|