Oracle通过日期获取星座函数

create or replace function get_xingzuo(dt in date) RETURN V ARCHAR2 is xingzuo VARCHAR2(20);

dnum number(4);

begin

dnum:=to_number(to_char(dt,'MMdd'));

select case

when dnum>=1222 or dnum<=119 then '摩羯座'

when dnum>=120 and dnum<=218 then '水瓶座'

when dnum>=219 and dnum<=320 then '双鱼座'

when dnum>=321 and dnum<=420 then '牡羊座'

when dnum>=421 and dnum<=520 then '金牛座'

when dnum>=521 and dnum<=621 then '双子座'

when dnum>=622 and dnum<=722 then '巨蟹座'

when dnum>=723 and dnum<=822 then '狮子座'

when dnum>=823 and dnum<=922 then '处女座'

when dnum>=923 and dnum<=1022 then '天秤座'

when dnum>=1023 and dnum<=1121 then '天蝎座'

when dnum>=1122 and dnum<=1221 then '射手座'

end into xingzuo from dual;

return xingzuo;

end;