Approximate Numeric Data Types
The following types are members of the ANSI/ISO SQL:2011 approximate predefined numeric set.
Although FLOAT, REAL, and DOUBLE PRECISION are distinct types as defined by the ANSI/ISO SQL:2011 standard, Teradata Database treats them as if they are equivalent to one another. The approximate numeric data types represent floating point numbers.
See SQL Data Types and Literals for more detailed information about the various approximate numeric data types supported by Teradata Database.