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:无效的月份错误;不知道是什么原因。刚开始以为三个列就够了,后来又多加了一个,单独对这个列插值
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:无效的月份错误;不知道是什么原因。刚开始以为三个列就够了,后来又多加了一个,单独对这个列插值
如这种格式.TO_DATE('1987-06-17','YYYY-MM-DD')
SET hire_date=TO_DATE('1987-01-17','yyyy-mm-dd')
WHERE last_name='King';
UPDATE employee
SET hire_date=TO_DATE('1987-01-17', 'YYYY-MM-DD', 'NLS_DATE_LANGUAGE = American')
WHERE last_name='King';