Float values being rounded when fetching from Teradata
969058Oct 17 2012 — edited Oct 18 2012I am trying to query a Teradata database by using a link from OracleXE. When I fetch a value defined in Teradata as a 'float', the value is automatically being rounded.
Value when querying Teradata from OracleXE:
0.0166979
Value when directly querying Teradata:
0.01669787586530
Has anyone encountered this before. I have tried to cast the value to a number/varchar2 within Oracle, but it seems as if the number is being rounded prior to being able to apply any data type conversions.