FIXED

FIXED returns the fixed-point value of x, with a precision specified by p and q. The result has the base and mode of x.
Read syntax diagramSkip visual syntax diagram
>>-FIXED(x-+-----------+-)-------------------------------------><
           '-,p-+----+-'     
                '-,q-'       

x
Expression.
p
Restricted expression that specifies the total number of digits in the result. It must not exceed the implementation limit.
q
Restricted expression that specifies the scaling factor of the result. If q is omitted, a scaling factor of zero is assumed.

If both p and q are omitted, the default values, (15,0) for a binary result or (5,0) for a decimal result, are used.






Published: 23 December 2018