SELECT DECODE(SIGN(SUBSTR('20001003',5) - SUBSTR('19801004',5)),-1,SUBSTR('2000-10-03',1,4)-SUBSTR('1980-10-04',1,4)-1,SUBSTR('2000-10-03',1,4)-SUBSTR('1980-10-04',1,4)) "age" FROM DUAL;SQL> SELECT DECODE(SIGN(SUBSTR('20001003',5) - SUBSTR('19801004',5)),-1,SUBSTR('2000-10-03',1,4)-SUBSTR('1980-10-04',1,4)-1,SUBSTR('2000-10-03',1,4)-SUBSTR('1980-10-04',1,4)) "age" FROM DUAL; age
----------
19
----------
19
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货