SELECT FLOOR(MONTHS_BETWEEN(SYSDATE,birthday)/12,1) FROM ltteacherinfo where name='朱雪东111'
这个报错ORA 00909 :invalid number of arguments这个是怎么错了,计算年龄该怎么算,年龄要整数
--计算员工年龄
SELECT FLOOR(MONTHS_BETWEEN(SYSDATE,birthdate)/12) FROM ps_personal_data
SELECT FLOOR(MONTHS_BETWEEN(SYSDATE,birthday)/12,1) FROM ltteacherinfo where name='朱雪东111'
这个报错ORA 00909 :invalid number of arguments这个是怎么错了,计算年龄该怎么算,年龄要整数
--计算员工年龄
SELECT FLOOR(MONTHS_BETWEEN(SYSDATE,birthdate)/12) FROM ps_personal_data