如何通过出生日期得到年龄

Question

(sysdate - birthdate)/365然后取整一下咯

Answer 1

trunc(sysdate,'year')-trunc(birthday,'year')

Answer 2

trunc(sysdate,'yyyy')-trunc(birthday,'yyyy')  --公元后

Answer 3

to_char(sysdate,'yyyy')-to_char(birthday,'yyyy')

Answer 4

叹息 都没有正确的还是我自己的吧 to_number(to_char(sysdate,'yyyy')) -  to_number(to_char(csrq ,'yyyy'))

Answer 5

叹息 都没有正确的还是我自己的吧 to_number(to_char(sysdate,'yyyy')) -  to_number(to_char(csrq ,'yyyy'))