SELECT EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM TO_DATE('2011-06-05','YYYY-MM-DD')) YEARS FROM DUAL;
ORACLE 两日期相差年数
最新推荐文章于 2024-01-03 17:47:38 发布
SELECT EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM TO_DATE('2011-06-05','YYYY-MM-DD')) YEARS FROM DUAL;