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

FRACTIONAL_PART

This is not an SQL function but can be achieved by subtracting the integer part of the value from the value itself:

Value - CAST(FloatValue AS INTEGER)

This will extract the fractional part of a floating point number and disregard the interger part of the value.

 

See also INTEGER_PART

 

Supplementary notes on LocalSQL added by Niels Knabe