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;
把字符串转换为数字,转换不成功返回NUL
最新推荐文章于 2021-12-28 13:54:46 发布