Entrypoint roundfloat compatible with UTF-8
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
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;