Perfect

1 million of thanks
=========
|| ISMAEL ||
=========

----- Original Message -----
From: Huan Ruan
To: firebird-support@yahoogroups.com
Sent: Thursday, March 29, 2012 5:13 PM
Subject: Re: [firebird-support] Arithmetic overflow or division by zero has occurred.



On 30 March 2012 03:21, Ismael L. Donis Garcia <ismael@...>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]





[Non-text portions of this message have been removed]