# trunc({n}\[,{m}])

Returns the value of the numeric expression *n* truncated to *m* decimal places. *m* can be negative, in which case the function returns *n* truncated to -*m* places to the left of the decimal point. If *m* is omitted, it returns *n* truncated to the integer place. *n* can be any real numeric value in the range of -1.797e308 <= *n* <= 1.797e308. *m* can be an integer value between -15 and 15 inclusive.

`trunc({n}[,{m}])` takes the following syntax.

```nolang
SELECT trunc(N[,M]) as AliasName
FROM dataset;
```

## Example

This example returns 47.385 truncated to the second decimal place.

```nolang
SELECT trunc(47.385, 2) as truncExample FROM Superstore
LIMIT 1;
```

| truncExample |
| ------------ |
| 47.38        |