年龄算法（Age algorithm）.docVIP

年龄算法（Age algorithm） function fun _ get _ nl (for _ csrq dates, to _ dqrq dates, as _ xz in varchar2) return varchar2 is result varchar2 (50). no _ months number; no _ days number; no _ year number. d _ dqrq dates; s _ xz varchar2 (20). s _ nl varchar2 (50). begin if to _ csrq is null or to _ csrq = to _ dates (1900 - 1 - 1 , yyyy-mm-dd ) then result: = ; return (result); end if; if to _ dqrq is null or to _ dqrq = to _ dates (1900 - 1 - 1 , yyyy-mm-dd ) then d _ dqrq: = sysdate; else d _ dqrq: = _ dqrq; end if; if as _ xz is null then d = _ xz: banlsf; else s _ xz = as _ xz. end if; - 计算日数 s