INT() Function - Decimal to Integer

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