为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8
【操作系统】:win0
【CPU】:
【问题描述】*: mysql中的自定义函数,dm怎么创建
CREATE DEFINER=******
@%
FUNCTION sumworkday
(start_day DATETIME,
work_days INT) RETURNS int(11)
BEGIN
DECLARE mid_date int;
set mid_date =work_days -(DATEDIFF(SYSDATE(),start_day) -(select count(1) from l_holiday where start_day < holiday and holiday < SYSDATE()));
RETURN mid_date;
END
CREATE OR REPLACE FUNCTION sumworkday(start_day DATETIME,work_days INT)
return int
as
mid_date int;
BEGIN
mid_date := work_days-(DATEDIFF(dd,SYSDATE(),start_day)-(select count(1) from l_holiday where start_day < holiday and holiday < SYSDATE()));
RETURN mid_date;
END;