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.
|
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 |