SQL - INT() Function

Syntax

INT(num)

Description

The INT() function returns its numeric argument with any fractional digits removed and truncates all digits to the right of the decimal point.

Example

Select INT(CURR_BAL) from Customer



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.