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.
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) |
|
a is a NULL value |
|
a is a special NULL value |
Special NULL value |