例如表名为table,时间字段名为col,格式为yyyymmdd hh24missupdate tableset col = col + (select min(ROUND(TO_NUMBER(sysdate -to_date(col,'yyyymmdd hh24miss')) * 24 * 60 * 60))from table);
