decode(trunc(months_between(a.APPLY_TIME ,b.birthdate),0),0,trunc(a.APPLY_TIME - b.birthdate,0)||'天',decode(trunc(months_between(a.APPLY_TIME,b.birthdate)/12,0),0,trunc(months_between(a.APPLY_TIME,b.birthdate),0)||'个月',trunc(months_between(a.APPLY_TIME,b.birthdate)/12,0)||'岁')) as 年龄
判断年龄算法日记
最新推荐文章于 2024-08-19 17:05:31 发布