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