<< Click to Display Table of Contents >> Navigation:  Notes on Local SQL > SQL INTEGER_PART

INTEGER_PART

This is not an SQL function but can be achieved by a simple CAST of a real number into INTEGER:

CAST(FloatValue AS INTEGER)

This will do a simple truncation disregarding the decimal value.

 

See also FRACTIONAL_PART

 

Supplementary notes on LocalSQL added by Niels Knabe