1.更新日期减去15天
update t_ccspsq set SQSJ=(select SQSJ+numtodsinterval(-15,'day')
from t_ccspsq where ID=18755) where ID=18755;
更新 年月将day换成year,month
1.更新日期减去15天
update t_ccspsq set SQSJ=(select SQSJ+numtodsinterval(-15,'day')
from t_ccspsq where ID=18755) where ID=18755;
更新 年月将day换成year,month