和mysql不同,mysql 可以直接插入 时间字符串的,
UPDATE HR_EFF_EVALUATOR
SET LEVEL_ = '2', ROLE_NAME_ = '他评', ASSESS_ROLE_ = '具体人员', ASSESS_WAY_ = '10', WEIGHT_ = '百分制', NOTE_ = '欧敏测试', PLAN_ID_ = '110001231000002', STATUS_ = '0', CREATE_TIME_=TO_DATE('2016-12-07 12:12:12','YYYY-MM-DD HH24:MI:SS'), PEOPLE_NAME_ = '评估人员' WHERE ID_ = '110001357000038'这样时间就有 时分秒了
如果只要年月日必须是
UPDATE HR_EFF_EVALUATOR
SET LEVEL_ = '2', ROLE_NAME_ = '他评', ASSESS_ROLE_ = '具体人员', ASSESS_WAY_ = '10', WEIGHT_ = '百分制', NOTE_ = '欧敏测试', PLAN_ID_ = '110001231000002', STATUS_ = '0', CREATE_TIME_=TO_DATE('2016-12-07','YYYY-MM-DD'), PEOPLE_NAME_ = '评估人员' WHERE ID_ = '110001357000038'否则会报错的