Argument | Required/ Optional | Description |
---|---|---|
value | Required | String or numeric datatype. Passes the value you want to convert to a bigint value. You can enter any valid expression. |
flag | Optional | Specifies whether to truncate or round the decimal portion. The flag must be an integer literal or the constants TRUE or FALSE:
The flag is not set by default. |
IN_TAX | RETURN VALUE |
---|---|
'7,245,176,201,123,435.6789' | 7,245,176,201,123,435 |
'7,245,176,201,123,435.2' | 7,245,176,201,123,435 |
'7,245,176,201,123,435.2.48' | 7,245,176,201,123,435 |
NULL | NULL |
'A12.3Grove' | 0 |
' 176,201,123,435.87' | 176,201,123,435 |
'-7,245,176,201,123,435.2’ | -7,245,176,201,123,435 |
'-7,245,176,201,123,435.23' | -7,245,176,201,123,435 |
-9,223,372,036,854,775,806.9 | -9,223,372,036,854,775,806 |
9,223,372,036,854,775,806.9 | 9,223,372,036,854,775,806 |
IN_TAX | RETURN VALUE |
---|---|
'7,245,176,201,123,435.6789' | 7,245,176,201,123,436 |
'7,245,176,201,123,435.2' | 7,245,176,201,123,435 |
'7,245,176,201,123,435.348' | 7,245,176,201,123,435 |
NULL | NULL |
'A12.3Grove' | 0 |
' 176,201,123,435.87' | 176,201,123,436 |
'-7,245,176,201,123,435.6789' | -7,245,176,201,123,436 |
'-7,245,176,201,123,435.23' | -7,245,176,201,123,435 |
-9,223,372,036,854,775,806.9 | -9,223,372,036,854,775,807 |
9,223,372,036,854,775,806.9 | 9,223,372,036,854,775,807 |