15.00 - Approximate Numeric Data Types - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Approximate Numeric Data Types

The following types are members of the ANSI/ISO SQL:2011 approximate predefined numeric set.

  • DOUBLE PRECISION
  • FLOAT
  • REAL
  • 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.