没有什么技术含量但是复制粘贴总是好的,基本一看就懂,替换时间就行了,在oracle里测试可用。非要填个大于当前时间的日期,当我没说告辞
select
case
when substr(to_char(sysdate,'yyyymmdd'),0,4) - substr('20200613',0,4)>0 then
substr(to_char(sysdate,'yyyymmdd'),0,4) - substr('20200613',0,4) || '岁'
when substr(to_char(sysdate,'yyyymmdd'),5,2) - substr('20200613',5,2)>0 then
substr(to_char(sysdate,'yyyymmdd'),5,2) - substr('20200613',5,2) || '月'
when substr(to_char(sysdate,'yyyymmdd'),7,2) - substr('20200613',7,2)>6 then
to_number( to_number( substr(to_char(sysdate,'yyyymmdd'),7,2) - substr('20200613',7,2))/7) || '周'
else
substr(to_char(sysdate,'yyyymmdd'),7,2) - substr('20200613',7,2) || '天'
end as Age
from dual
文章评论