FLOAT(a,p) 
FLOAT(a,p) is an arithmetic function that outputs the expression a (a number) in a format of the data type FLOAT(p) (p is an unsigned integer). It is rounded to p places if necessary.
a, p |
Result of the FLOAT(a,s) function |
|---|---|
a is a NULL value |
NULL value |
a is a special NULL value |
Special NULL value |