Conversion From Float to Integer
There are different funtions for conversion from float to integer, which differ with respect to handling of the fractional part of the float.
INT(),FLOOR() | Next lower integer number |
CEIL() | Next higher integer number |
ROUND() | Nearest integer number |
The floating point versions CEIL#, FLOOR# and ROUND# calculate the integer value but return it as floating point value. This is usefull, if the integer would exceed the integer range.
- FRACT# - Fractional Part of a Floating Point Number
|