怎么显示ORA-01348:无效的月份错误；不知道是什么原因。

[jinlingxu]

create table employee(
employee_id number(10,0),
last_name varchar(15),
salary number(10,0)
)
ALTER TABLE employee
ADD hire_date date;

UPDATE employee
SET hire_date=TO_DATE('17-JAN-87','DD-MON-RR')
WHERE last_name='King';


INSERT INTO employee(hire_date)
values(TO_DATE('17-JUN-87','DD-MON-YY'))
WHERE last_name='King';

INSERT INTO (SELECT hire_date
FROM employee
WHERE last_name='King')
VALUES(TO_DATE('17-JUN-87','DD-MON-YY'));
怎么显示ORA-01348:无效的月份错误；不知道是什么原因。刚开始以为三个列就够了，后来又多加了一个，单独对这个列插值

[szflower]

你先在SQLPLUS下查条记录看一下你日期的格式是怎么样的．然后在插入对应的格式．
如这种格式．TO_DATE('1987-06-17','YYYY-MM-DD')

[BlueskyWide]

UPDATE employee 
       SET hire_date=TO_DATE('1987-01-17','yyyy-mm-dd') 
       WHERE last_name='King'; 

[Quote=引用楼主 jinlingxu 的帖子:]
create table employee(
employee_id number(10,0),
last_name varchar(15),
salary number(10,0)
)
ALTER TABLE employee
ADD hire_date date;

UPDATE employee
SET hire_date=TO_DATE('17-JAN-87','DD-MON-RR')
WHERE last_name='King';


INSERT INTO employee(hire_date)
values(TO_DATE('17-JUN-87','DD-MON-YY'))
WHERE last_name='King';

INSERT INTO (SELECT hire_date
…
[/Quote]

[mantisXF]

-- 或者这样写:
UPDATE employee 
SET hire_date=TO_DATE('1987-01-17', 'YYYY-MM-DD', 'NLS_DATE_LANGUAGE = American') 
WHERE last_name='King';

[Quote=引用楼主 jinlingxu 的帖子:]
create table employee(
employee_id number(10,0),
last_name varchar(15),
salary number(10,0)
)
ALTER TABLE employee
ADD hire_date date;

UPDATE employee
SET hire_date=TO_DATE('17-JAN-87','DD-MON-RR')
WHERE last_name='King';


INSERT INTO employee(hire_date)
values(TO_DATE('17-JUN-87','DD-MON-YY'))
WHERE last_name='King';

INSERT INTO (SELECT hire_date
…
[/Quote]