BIGDECIMAL
Syntax
BIGDECIMAL(<number>)
Description
Converts the values of a column with a number data type to the big decimal data type.
Examples
Field type | Number | BIGDECIMAL returns |
|---|---|---|
Integer | 10 | 10 |
Integer | -345352 | -345352 |
Big Integer | 10,223,372,036,854,775,458,938,943 | 10,223,372,036,854,775,458,938,943 |
Big Integer | -1,329,223,372,036,854,775,807,934 | -1,329,223,372,036,854,775,807,934 |
Float | 10.3 | 10.3 |
Float | 33.333333333 | 33.333333333 |