Ispirer SQLWays Database Migration Software

DOUBLE, DOUBLE PRECISION and REAL

DOUBLE[(p,s)] [UNSIGNED]

A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E- 308 to 1.7976931348623157E+308.

The p is the precision, or the total number of digits. The s is the scale, or the number of digits to the right of the decimal point.

DOUBLE without arguments stands for a double-precision floating-point number.

If UNSIGNED is specified, negative values are not allowed.

DOUBLE PRECISION[(p,s)] [UNSIGNED]

REAL[(p,s)] [UNSIGNED]

These are synonyms for DOUBLE.

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.