Decimal data type applies to floating points up to 15 digits in length.
|
Punctuation such as commas and dollar signs ($) are not supported. These markers must be removed from numeric values through transformation steps before you can change the type to Decimal.
The following range is considered safe for values of this type. There may be inconsistencies in output for values outside this range:
4.9406564584124654e-324
1.7976931348623157e+308
Notes:
Examples:
123.45
3000.00
1.2345678E+22
7.4423e-12
-4.123e+12