DECIMAL returns the decimal value of
x, with a precision
specified by
p and
q. The result has the mode and
scale of
x.
>>-DECIMAL(x-+-----------+-)-----------------------------------><
'-,p-+----+-'
'-,q-'
Abbreviation: DEC
- x
- Reference.
- p
- Restricted expression specifying the number of digits to be
maintained throughout the operation.
- q
- Restricted expression specifying the scaling factor of the result.
For a fixed-point result, if p is given and q is
omitted, a scaling factor of zero is assumed. For a floating-point
result, q must be omitted.
If both p and q are omitted, the precision of
the result is determined from the rules for base conversion.