Values of float are truncated when converted to any integer type.
When you are converting from float or real to character data, the string function STR( ) is usually a better choice than CAST( ), because STR( ) gives you more control over formatting. For more information, see Functions.
CAST and CONVERT | Data Types |