注册

自定义函数查询为空

one piece 2023/08/15 713 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:win
【CPU】:i7-8
【问题描述】*:自定义函数输入查询为空
CREATE OR REPLACE FUNCTION "SYSDBA"."XXTT"("NTYPE" IN INT)
RETURN INT
AUTHID DEFINER

AS
/变量说明部分/
xxFS varchar;
BEGIN
/执行体/
IF(nType = 1) THEN
xxFS := 'cs';
END IF;
IF(nType = 2) THEN
xxFS := to_Char(DATEADD(wk, DATEDIFF(wk,0,getdate()), 0),'YYYY-MM-DD') || '-' || to_Char(dateadd(ms,-3,DATEADD(wk, DATEDIFF(wk,0,getdate()) +1, 0)),'YYYY-MM-DD');
END IF;
IF(nType = 3) THEN
xxFS := to_Char(dateadd(mm, datediff(mm,0,getdate()), 0),'YYYY-MM-DD') || '-' || to_Char(dateadd(ms,-3,dateadd(mm, datediff(mm,0,getdate())+1, 0)),'YYYY-MM-DD');
END IF;
IF(nType = 4) THEN
xxFS := to_Char(dateadd(qq, datediff(qq,0,getdate()), 0),'YYYY-MM-DD') || '-' || to_Char(DATEADD(ms,-3,dateadd(qq, datediff(qq,0,getdate())+1, 0)),'YYYY-MM-DD');
END IF;
IF(nType = 5) THEN
xxFS := to_Char(dateadd(yy, datediff(yy,0,getdate()), 0),'YYYY-MM-DD') || '-' || to_Char(dateadd(ms,-3,dateadd(yy, datediff(yy,0,getdate())+1, 0)),'YYYY-MM-DD');
END IF;
END;

回答 0
暂无回答
扫一扫
联系客服