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 |