select * from TDA_ARCHIVE a where (select to_number(to_char(sysdate,'yyyy'))-to_number(to_char(a.CREATE_DATE,'yyyy')) from dual)>(select code from TDM_ENUMITEM b where a.STORETERM_ID = b.ENUMID
如何改为兼容as400 db2？
------解决方案--------------------------------------------------------
帮你顶起，学习一下
------解决方案--------------------------------------------------------
select * from TDA_ARCHIVE a where (select year(current date) - yeaer(a.CREATE_DATE) from sysibm.sysdummy1)>(select code from TDM_ENUMITEM b where a.STORETERM_ID = b.ENUMID
------解决方案--------------------------------------------------------
DB2直接用YEAR，表用1个系统表OR 已经存在的任意表，假设任意表为TT
select * from TDA_ARCHIVE a where (select DISTINCT year(current date) - yeaer(a.CREATE_DATE) from TT)>(select code from TDM_ENUMITEM b where a.STORETERM_ID = b.ENUMID