方法一:新增字段设置不为空且默认值为sysdate
方法二:在insert语句中加sysdate
insert into T_XZ_CASEINFO
(case_id,
case_no,
case_type,
casestate,
cause_action,
admin_area,
caselocroadid,
caselevel,
case_source,
unitid,
deptid,
case_time,
checkdate,
registdate,
casefiledate,
caseenddate,
casesealdate,
casecancledate,
relatedcaseid,
memo1,
memo2,
isbatchflag,
ismodifyflag,
caseuniquecode,
ZHIDUI,
LAOXITONG,
DEFAULTTIME)
Values
(:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
:s,
2,
1,
sysdate)