Skip to main content
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

ParameterDescriptionSupported 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

​
Examples

Example The following example returns the truncated value of -20.5: 
SELECT TRUNC(-20.5);
trunc double
-20

Rows: 1Execution time: 5.83ms

Example The following example returns the truncated value of -99.999999 to 3 decimal places: 
SELECT TRUNC(-99.999999, 3);
trunc double
-99.999

Rows: 1Execution time: 5.83ms