meta data for this page
  •  

F_FIXEDPOINTLANG

function from adhoc

Entrypoint fixedpoint compatible with UTF-8

Inputs/Outputs

   Input     DOUBLE floatingpoint to be round
             INTEGER	number of digits to be round
   Output    CSTRING(32)	floatingpoint as a string

Syntax

   The method of rounding is round to even like F_ROUNDTOEVEN.
   In difference to F_ZAHLRUNDEN the output is a String!
   In string-expenditure the decimal-separator is a "."
   TestSQL
   SELECT '12345.5' AS ISCORRECT, F_FIXEDPOINT(12345.46, 1) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_FIXEDPOINT(NULL, NULL) FROM RDB$DATABASE;