meta data for this page
  •  

F_ROUND

input/output-compatibility to FreeUDFLibC

Entrypoint f_round compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE        floatingpoint to be round as an integer
   Output     INTEGER	      integer

Syntax

   The method of rounding is the common method like F_ZAHLRUNDEN.
   Because there is a same-named function in C we must change the entrypoint from round to f_round. Therefore now NO entryppoint-compatibility to FreeUDFLibC.
   TestSQL
   SELECT 16 AS ISCORRECT, F_ROUND(15.567) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ROUND(NULL) FROM RDB$DATABASE;