meta data for this page
  •  

F_DOLLARVAL, F_CONVERTTODOLLAR

compatibility FreeUDFLib, FreeUDFLib AvERP

compatibility FreeUDFLibC

Entrypoint converttodollar compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE           floatingpoint
   Output     CSTRING(32)      Dollar-floatingpoint ($ in front of the number) (rounded to 2 digits)

Syntax

   TestSQL
   SELECT '$15.68' AS ISCORRECT, F_CONVERTTODOLLAR(15.678) FROM RDB$DATABASE;
   SELECT '$15.68' AS ISCORRECT, F_DOLLARVAL(15.678) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_DOLLARVAL(NULL) FROM RDB$DATABASE;