Hello all,
In the documentation on numerics it mentions for REAL and DOUBLE precision that the result will not always be the same but an approximation.
Case in point :- a value from our data which is inserted into a DOUBLE
119.68753814697266
when selected from crate is
119.68646766399515
Can I ask why this is the case ? Are we supposed to use the NUMERIC function for selecting to get a more accurate value ?
Many thanks
David