摘要: 方法一: SELECT TRUNC(months_between(sysdate, birth)/12) AS age from dual; 方法二: select TRUNC((to_char(sysdate, 'yyyyMMdd') - to_char(birth, 'yyyyMMdd')) / 阅读全文
posted @ 2020-06-23 12:01 江湖小虾米L 阅读(1251) 评论(0) 推荐(0)