select floor(MONTHS_BETWEEN(sysdate,date'2000-1-1')/12) from dual
正解
SELECT FLOOR(MONTHS_BETWEEN(SYSDATE,birthday)/12,1) FROM ltteacherinfo where name='seven'
SELECT FLOOR(MONTHS_BETWEEN(SYSDATE,birthday)/12,1) FROM ltteacherinfo where name='seven'