Sybase Adaptive Server Anywhere - Page 288

Numeric data types
270
"FLOAT data type" on page 270
"REAL data type" on page 272
"DOUBLE data type" on page 270
DOUBLE data type [Numeric]
A double-precision floating-point number.
DOUBLE [ PRECISION ]
The DOUBLE data type holds a double-precision floating point number. An
approximate numeric data type, it is subject to roundoff errors after
arithmetic operations. The approximate nature of DOUBLE values means
that queries using equalities should generally be avoided when comparing
DOUBLE values.
DOUBLE values require 8 bytes of storage.
The range of values is 2.22507385850721e-308 to 1.79769313486231e+308.
Values held as DOUBLE are accurate to 15 significant digits, but may be
subject to round-off error beyond the fifteenth digit.
♦
SQL/92 Compatible with SQL/92.
♦
Sybase Compatible with Adaptive Server Enterprise.
"FLOAT data type" on page 270
"REAL data type" on page 272
"DECIMAL data type" on page 269
FLOAT data type [Numeric]
A floating point number, which may be single or double precision.
FLOAT [ ( precision ) ]
When a column is created using the FLOAT ( precision ) data type, columns
on all platforms are guaranteed to hold the values to at least the specified
minimum precision. In contrast, REAL and DOUBLE do not guarantee a
platform-independent minimum precision.
If precision is not supplied, the FLOAT data type is a single precision
floating point number, equivalent to the REAL data type, and requires 4
bytes of storage.
See also
Function
Syntax
Usage
Standards and
compatibility
See also
Function
Syntax
Usage