TRUNC
Returns the rounded absolute value of a numeric value. The returned value will always be rounded to less than the original value.
Syntax
TRUNC(<value>[, <decimal>])
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<value> | Valid values include column names, functions that return a column with numeric values, and constant numeric values. | DOUBLE PRECISION |
<decimal> | Optional. An INTEGER constant that defines the decimal range of the returned value. By default, TRUNC returns whole numbers. | INTEGER |
Return Type
DOUBLE PRECISION
Example
The following example returns the truncated value of -20.5:
SELECT
TRUNC(-20.5);
Returns: -20
This example returns the truncated value of -99.999999 to 3 decimal places:
SELECT
TRUNC(-99.999999, 3);
Returns: -99.999