meta data for this page
  •  

F_SOFTROUND

input/output-compatibility to rFunc (SOFTROUND)

Entrypoint softround compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE       floatingpoint to be round
              INTEGER	     number of digits to be round
   Output     INTEGER	     floatingpoint rounded to integer

Syntax

   The method of rounding is similar to F_ZAHLRUNDEN.
   If the result of rounding would be 0, than the result is the non-rounded value.
   TestSQL
   SELECT 0.0016 AS ISCORRECT, F_SOFTROUND(0.0016, 2), F_ZAHLRUNDEN(0.0016, 2) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_SOFTROUND(NULL, NULL) FROM RDB$DATABASE;