56,687
社区成员
发帖
与我相关
我的任务
分享
DROP FUNCTION IF EXISTS fn_name;
delimiter //
CREATE FUNCTION fn_name (DailyDate DATETIME,returntype SMALLINT)
RETURNS DECIMAL(18, 1)
BEGIN
DECLARE BDate DATETIME;
DECLARE qty_return DECIMAL(18, 1); DECLARE `MaxValue` DECIMAL(18, 1); DECLARE `MinValue` DECIMAL(18, 1);
SET qty_return = 0;
SELECT `MaxValue` = ROUND(IFNULL(MAX(Airtemp),0),1) , `MinValue` = ROUND(IFNULL(MIN(Airtemp),0),1)
FROM tbl_name WHERE InDateTime > DATE_ADD(BDate, INTERVAL 23 HOUR) AND InDateTime < DATE_ADD(BDate, INTERVAL '1 0:5' DAY_MINUTE);
IF (returntype = 0) THEN SET qty_return = `MinValue` ; ELSEIF (returntype = 1) THEN SET qty_return = `MaxValue`; END IF; RETURN qty_return; END//
delimiter ;
SELECT `MaxValue` = ROUND(IFNULL(MAX(Airtemp),0),1) , `MinValue` = ROUND(IFNULL(MIN(Airtemp),0),1)
FROM hy_tmpr_c WHERE SingInDateTime > DATE_ADD(BDate, INTERVAL 23 HOUR) AND SingInDateTime < DATE_ADD(BDate, INTERVAL '1 0:5' DAY_MINUTE);