Returns the truncated amount by removing any decimal part of that amount beyond the number of digits specified.

TRUNC(Amount, Digits)

Amount: number to be truncated.

Digits: number of digits to which amount should be truncated.

If the digits value is negative, truncating is done to the left of the decimal point.

TRUNC(5.455, 1) equals 5.4

TRUNC(150,-2) equals 100

TRUNC(-5.4,0) equals -5