TRUNC

Returns the integer portion of the given number dropping any fractional portion.

Syntax

TRUNC(number)

Arguments

number -  any number.

Examples

TRUNC(9.99  = 9

TRUNC(-9.99) = -9