CREATE OR REPLACE FUNCTION ISQUARTER(MyStr DATE)
RETURN VARCHAR2
IS
sResult VARCHAR2(400);
BEGIN
select to_char(MyStr,'yyyy') || lpad(TO_CHAR(MyStr,'Q'),2,'0') INTO sResult from dual;
RETURN sResult;
END;
根据日期返回所在的季度---oracle 函数
最新推荐文章于 2024-07-19 14:51:10 发布