Oracle上测试
示例:查询截止期两月前的数据
SYSDATE > ( SELECT ADD_MONTHS (XKJZQ, - 2) FROM dual )
eg:
1.查询上个月
SELECT ADD_MONTHS (sysdate, - 1) FROM dual
2.查询明年
SELECT ADD_MONTHS (sysdate, 12) FROM dual
以此类推
Oracle上测试
示例:查询截止期两月前的数据
SYSDATE > ( SELECT ADD_MONTHS (XKJZQ, - 2) FROM dual )
eg:
1.查询上个月
SELECT ADD_MONTHS (sysdate, - 1) FROM dual
2.查询明年
SELECT ADD_MONTHS (sysdate, 12) FROM dual
以此类推