| Subject | Re: [firebird-support] strange bahaviour |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2019-07-04T09:21:13Z |
If you were using dialect 1, I would say the difference would be expected (since NUMERIC(18) is equal to DOUBLE PRECISION in dialect 1), but I guess you're using dialect 3?
What do you get if you run:
SELECT ID, IMPORTO - TRUNC(IMPORTO), PAGATO - TRUNC(PAGATO)
FROM ELENCO_SCADENZE
What do you get if you run:
SELECT ID, IMPORTO - TRUNC(IMPORTO), PAGATO - TRUNC(PAGATO)
FROM ELENCO_SCADENZE
Is the problem the same after
UPDATE
ELENCO_SCADENZE
SET
IMPORTO = TRUNC(IMPORTO, 2)
UPDATE
ELENCO_SCADENZE
SET
IMPORTO = TRUNC(IMPORTO, 2)
HTH,
Set
ons. 3. jul. 2019 kl. 17:27 skrev Luigi Siciliano luigisic@... [firebird-support] <firebird-support@yahoogroups.com>:
Hallo,
Il 03/07/2019 16:35, liviuslivius liviuslivius@... [firebird-support] ha scritto:
What are the exact types of both fields?NUMERIC(18,4) via domain:
CREATE DOMAIN CURRENCY_D
Thanks.
AS Numeric(18,4)
DEFAULT 0.00
NOT NULL
;
--
Luigi Siciliano --------------------------