从SYSDATE减去一个日期会产生负面结果:
select floor(SYSDATE - dateemb) from pilote;
FLOOR(SYSDATE-DATEEMB)
----------------------
-29126
-29137
-29522任何解决方案?
表pilote:
Name Null? Type
----------------------------------------- -------- ----------------------------
NUMPIL NOT NULL NUMBER
NOMPIL VARCHAR2(25)
ADRPIL VARCHAR2(25)
SALAIRE NUMBER
COMMISSION NUMBER
DATEEMB DATE使用的数据:
NUMPIL NOMPIL ADRPIL SALAIRE COMMISSION DATEEMB
------- -------- -------- -------- ---------- ---------
1333 FEDOI NANTES 24000 0 01-MAR-92
6589 DUVAL PARIS 18600 5580 12-MAR-92
7100 MARTIN LYON 15600 16000 01-APR-93