This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

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>])

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

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