On 30 March 2012 03:21, Ismael L. Donis Garcia <[email protected]>wrote:
> ** > > > That operation does not give the precision that I need ( 6 digits after > decimal point ) > > SELECT 54311.999455*cast((1/1.000001) as integer) as mount FROM > MON$ATTACHMENTS r = 54311.999455 > > 54311.999455 / 1.000001 = 54311,945143 > Cast one of the numbers in your calculation as "double precision", e.g. SELECT cast(cast(54311.999455 as double precision)/1.000001 as numeric(16,6)) as mount FROM rdb$database Cheers Huan [Non-text portions of this message have been removed]
