oracle存储过程通过生日计算年龄,自定义oracle版函数来计算年龄（规则一）

CREATE OR REPLACE FUNCTION uf_get_age(ad_csrq IN date, ad_dqrq IN date)

RETURN VARCHAR2 IS

RESULT   VARCHAR2(50);

n_months number;

n_days   number;

t_days   number(18,1);

d_dqrq   date;

s_nl     VARCHAR2(50);

s_ts     VARCHAR2(50);

BEGIN

Begin

IF ad_csrq is null OR ad_csrq <= TO_DATE('1900-1-1', 'YYYY-MM-DD') OR

ad_csrq > ad_dqrq THEN

RESULT := '';

RETURN(RESULT);

END IF;

IF ad_dqrq is null OR ad_dqrq <= TO_DATE('1900-1-1', 'YYYY-MM-DD') THEN

d_dqrq := SYSDATE;

ELSE

d_dqrq := ad_dqrq;

END IF;

-- 以实(周)岁 算*/

select to_number(to_char(d_dqrq, 'YYYY')) * 12 +

to_number(to_char(d_dqrq, 'MM')) -

(to_number(to_char(ad_csrq, 'YYYY')) * 12 +