meta data for this page
  •  

F_ROUNDFLOAT

compatibility FreeUDFLib, FreeUDFLib AvERP

Entrypoint roundfloat compatible with UTF-8

Inputs/Outputs

   Input     DOUBLE     floatingpoint to be round
             DOUBLE     output pattern for floatingpoint (e.g. 0.01) rounds on the next multiple of    parameter 2
                        parameter 2
   Output    DOUBLE     floatingpoint

Syntax

   TestSQL
   SELECT 15.55 AS ISCORRECT, F_ROUNDFLOAT(15.567, 0.05) FROM RDB$DATABASE;
   SELECT 15.56 AS ISCORRECT, F_ROUNDFLOAT(15.567, 0.02) FROM RDB$DATABASE;
   SELECT 15.57 AS ISCORRECT, F_ROUNDFLOAT(15.567, 0.01) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ROUNDFLOAT(NULL, NULL) FROM RDB$DATABASE;