INT, FIX

The INT and FIX functions are used to return the integer portion of a number.

INT( number )

FIX( number )

The number argument can be any valid numeric expression. Both INT and FIX remove the fractional part of number and return the resulting integer value.

If the numeric expression results in a Null value, INT and FIX return a NaN.

The difference between INT and FIX is that if number is negative, INT returns the first negative integer less than or equal to the Number argument, whereas FIX returns the first negative integer greater than or equal to the Number. For example, INT converts -8.4 to -9, and FIX converts -8.4 to -8.

FIX(number) is equivalent to:

SGN(number) * INT(ABS(number))