- 论坛徽章:
- 0
|
我检查了下,确实是hire_date本身数据有问题,不好意思
SQL> select last_name,hire_date from employees;
LAST_NAME HIRE_DATE
-------------------- ------------
King 17-JUL-87
Kochhar 21-SEP-89
De Haan 13-JAN-93
Hunold 03-JAN-90
Ennst 21-MAY-91
Lorentz 07-FEB-99
Mourgos 15-NOV-99
Rajs 17-OCT-95
Davies 29-JAN-97
Matos 15-MAR-98
Vargas 09-JUL-98
SQL> select last_name,to_char(hire_date,'dd-mm-yyyy') from employees;
LAST_NAME TO_CHAR(HIRE_DATE,'D
-------------------- --------------------
King 17-07-2087
Kochhar 21-09-2089
De Haan 13-01-2093
Hunold 03-01-2090
Ennst 21-05-2091
Lorentz 07-02-2099
Mourgos 15-11-2099
Rajs 17-10-2095
Davies 29-01-2097
Matos 15-03-2098
Vargas 09-07-2098
我在网上找了条命令,已经修复
update employees set
hire_date =
to_date( '19' || substr(to_char(hire_date,'yyyymmdd'),3,2)
|| substr(to_char(hire_date,'yyyymmdd'),5,4),
'yyyy-mm-dd')
where substr(to_char(hire_date,'yyyymmdd'),1,4) like '20%';
SQL> select last_name,to_char(hire_date,'dd-mm-yyyy') from employees;
LAST_NAME TO_CHAR(HIRE_DATE,'D
-------------------- --------------------
King 17-07-1987
Kochhar 21-09-1989
De Haan 13-01-1993
Hunold 03-01-1990
Ennst 21-05-1991
Lorentz 07-02-1999
Mourgos 15-11-1999
Rajs 17-10-1995
Davies 29-01-1997
Matos 15-03-1998
Vargas 09-07-1998 |
|