> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for TRUNC function

# TRUNC

Returns the rounded absolute value of a numeric value. The returned value will always be rounded to less than the original value.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
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`:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
    TRUNC(-20.5);
```

**Returns**

`-20`

**Example**

The following code example returns the truncated value of `-99.999999` to `3` decimal places:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
    TRUNC(-99.999999, 3);
```

**Returns**

`-99.999`