17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> update test1 set datetime = date'2017-11-29' where datetime = to_date('02-AUG-17','DD-MON-YY', 'nls_date_language = American');
1 row updated
SQL> commit;
Commit complete
SQL> select * from test1;
DATETIME
-----------
2017-11-29
运行结果OK。
update test1 set datetime = date'2017-11-29' where datetime = to_date('02-AUG-17','DD-MON-YY', 'nls_date_language = American');