年份时间差
SELECT EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM TO_DATE(YOUR_DATE, 'YYYY-MM-DD')) YEARS_OLD FROM YOUR_TABLE
SELECT EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM TO_DATE(YOUR_DATE, 'YYYY-MM-DD')) YEARS_OLD FROM YOUR_TABLE
转载于:https://my.oschina.net/NamiZone/blog/2244672