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 +