从出生日期和今天开始的Oracle Age计算 [英] Oracle Age calculation from Date of birth and Today
本文介绍了从出生日期和今天开始的Oracle Age计算的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用的是(Today-Dob) / 30/12
,但这不准确,因为几个月有31天。
我需要以最高精度获得正确的年龄。我怎样才能做到这一点?
解决方案
SQL>选择trunc(months_between(sysdate,dob)/ 12)year,
2 trunc(mod(months_between(sysdate,dob),12))month,
3 trunc(sysdate-add_months(dob, month_between(sysdate,dob)/ 12)* 12 + trunc(mod(months_between(sysdate,dob),12))))day
4从(选择to_date('15122000','DDMMYYYY' );
YEAR MONTH DAY
---------- ---------- ----------
9 5 26
SQL>
I want to calculate the current Age from Date of Birth in my Oracle function.
What I am using is (Today-Dob)/30/12
, but this is not accurate as some months have 31 days.
I need to get the correct age with the maximum precision. How can I do that?
解决方案
SQL> select trunc(months_between(sysdate,dob)/12) year,
2 trunc(mod(months_between(sysdate,dob),12)) month,
3 trunc(sysdate-add_months(dob,trunc(months_between(sysdate,dob)/12)*12+trunc(mod(months_between(sysdate,dob),12)))) day
4 from (Select to_date('15122000','DDMMYYYY') dob from dual);
YEAR MONTH DAY
---------- ---------- ----------
9 5 26
SQL>
这篇关于从出生日期和今天开始的Oracle Age计算的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文