FIXED(a,p,s)

FIXED(a,p,s) is an arithmetic function that is used to output the expression a (a number) in a format of the data type FIXED(p,s) (p, s are unsigned integers).

Digits after the decimal point are rounded to s decimal places if necessary.

FIXED(a,p,s)
a, p, s	Result of the FIXED(a,p,s) function
s not specified	Result as for s=0
p not specified	Result as for p=38
ABS(a)>10exp(p-s)	Special NULL Value
a is a NULL value	NULL value
a is a special NULL value	Special NULL value

More Information

FIXED(p,s)