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

NULL value

a is a special NULL value

Special NULL value