Reference material for TRUNC function
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 |
DOUBLE PRECISION
-20.5
:
-20
Example
The following code example returns the truncated value of -99.999999
to 3
decimal places:
-99.999