# TRUNC

Returns the number **x** truncated to **d** decimal places. This is similar to the [TRUNCATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/truncate.md) function except that the precision (d) is not required.

If the precision is not specified, the number is truncated to **0** decimal places.

> **📝 Note**: If you do not specify a format, and if your value is not numeric, it will be treated like a [date](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/trunc.md).

## Syntax

```sql
TRUNC(x [,d])

```

## Arguments

* x: the number to be truncated
* d: the number of decimal places

## Return Type

Float or double.

## Examples

```sql
SELECT TRUNC(PI());

```

```output

+-------------+
| TRUNC(PI()) |
+-------------+
|           3 |
+-------------+

```

```sql
SELECT TRUNC(42.422, 1);

```

```output

+------------------+
| TRUNC(42.422, 1) |
+------------------+
|             42.4 |
+------------------+

```

***

Modified at: April 4, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/trunc/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/trunc/)

(An index of the documentation is available at /llms.txt)