trunc_numeric¶
This function is used to truncate the number value to a specified decimal place.
Syntax¶
trunc_numeric(<number>[, bigint<decimal_places>])
Parameters¶
Parameter | Mandatory | Type | Description |
---|---|---|---|
number | Yes | DOUBLE, BIGINT, DECIMAL, or STRING | Data to be truncated |
decimal_places | No | BIGINT | The default value is 0, indicating that the decimal place at which the number is truncated. |
Return Values¶
The return value is of the DOUBLE or DECIMAL type.
Note
The return rules are as follows:
If the number value is of the DOUBLE or DECIMAL type, the corresponding type is returned.
If the number value is of the STRING or BIGINT type, DOUBLE is returned.
If the decimal_places value is not of the BIGINT type, an error is reported.
If the value of number is NULL, NULL is returned.
Example Code¶
The value 3.141 is returned.
select trunc_numeric(3.1415926, 3);
The value 3 is returned.
select trunc_numeric(3.1415926);
An error is reported.
select trunc_numeric(3.1415926, 3.1);