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