STR#
Returns character data converted from numeric data.
Syntax#
STR ( float_expression [ , length [ , decimal ] ] )
Arguments#
float_expression
Is an expression of approximate numeric (float) data type with a decimal point.
length
Is the total length. This includes a decimal point, sign, digits, and spaces. The default is 10.
decimal
Is the number of places to the right of the decimal point. decimal must be less than or equal to 16. If decimal is more than 16 then the result is truncated to sixteen places to the right of the decimal point.
Return types#
varchar
Examples#
SELECT STR(123.45, 6, 1);