TRUNC

Reference material for TRUNC function

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

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