Whenever we use a define a Float column in Teradata and insert data into the column the data is always rounded off to 2 digits after the floating point.
For example I have a column in the table as col1(Float).I insert following values into the column:
But when I query the data it comes as:
respectively.Is this behaviour related to SQL assistant client settings or there is a separate reason for this?
It's not rounded when you insert the row, it's just a default display format in SQL Assistant:
Options -> Data Format -> Number of decimal places to display for Float columns
You can try CAST(floatcol AS NUMBER) to display all significant digits.