TRUNC(number, num_digits)

Truncates a number to the number of digits specified by num_digits.

Examples:

TRUNC(1.267, 0)  returns 1

TRUNC(1.267, 1)  returns 1.2

TRUNC(1.267, 2)  returns 1.26

Note that unlike ROUND(x, y) the TRUNC function makes no attempt to round a number up or down.

See also:

Other mathematical functions