2021-02-20

★DB2数据库对应的四舍五入六成双的存储函数

CREATE OR REPLACE FUNCTION DSJYDD.ROUND3 (P1 IN DOUBLE, P2 IN NUMBER) RETURN NUMBER

AS

BEGIN

   IF TRUNC(TO_NUMBER(P1),P2+1)<> TO_NUMBER(P1) OR SUBSTR(TO_NUMBER(P1) * POWER(10,P2+1),-1)<>'5' OR MOD(SUBSTR(TO_NUMBER(P1)*POWER(10,P2+1),-2,1),2)=1

   THEN

      RETURN ROUND(TO_NUMBER(P1),P2);

   ELSE

      RETURN TRUNC(TO_NUMBER(P1),P2);

   END IF;

END;

GO