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