meta data for this page
  •  

F_REMAINDER

function from adhoc

Entrypoint f_remainder UTF-8 kompatibel

Inputs/Outputs

   Input      DOUBLE     dividend (the number, which will be divided)
              DOUBLE     divisor (the number, by which one divides)
   Output     DOUBLE     Rest of the division of two numbers, parameter 1 is divided through parameter 2

Syntax

   TestSQL
   SELECT CAST(3 AS DOUBLE PRECISION) AS ISCORRECT, F_REMAINDER(15, 6) FROM RDB$DATABASE;
   SELECT CAST(0 AS DOUBLE PRECISION) AS ISCORRECT, F_REMAINDER(15, 5) FROM RDB$DATABASE;
   SELECT CAST(-1 AS DOUBLE PRECISION) AS ISCORRECT, F_REMAINDER(15, 4) FROM RDB$DATABASE;
   SELECT CAST(-0.4 AS DOUBLE PRECISION) AS ISCORRECT, F_REMAINDER(11.6, 2) FROM RDB$DATABASE;
   SELECT CAST(-1 AS DOUBLE PRECISION) AS ISCORRECT, F_REMAINDER(11.6, 2.1) FROM RDB$DATABASE;
   SELECT CAST(-3 AS DOUBLE PRECISION) AS ISCORRECT, F_REMAINDER(-15, 4) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_REMAINDER(NULL, NULL) FROM RDB$DATABASE;