SQL Reference Guide

Approximate Numeric Data Types

Refer to Numeric Literals for details on specifying values to be stored in numeric columns.

Syntax

approx_numeric_data_type ::

REAL

| DOUBLE [ PRECISION ]

| FLOAT [ (precision) ]

Arguments

• REAL

  Type REAL corresponds to a single precision floating point number equivalent to the C language float type.

• DOUBLE PRECISION

  Type DOUBLE PRECISION corresponds to a double precision floating point number equivalent to the C language double type.

  In V11 and later, DOUBLE can be used as an alias for DOUBLE PRECISION.

• FLOAT [ (precision) ]

  Type FLOAT corresponds to a double-precision floating point number of the given precision. By default, FLOAT columns have a precision of 8.