trunc

The trunc function truncates a given number to the specified precision, without rounding the value.

Category

Math

Return value

decimal, double, int, or real

The truncated number. The return data type is the same as the data type of <number>.

Where

<number>

The number from a source column.

<precision>

The number of decimals in the result. If <precision> is negative, the software truncates the digits to the left of the decimal point and pads the value with zeros.