[firebase-br] SQL - Arredondar Valor

[Joelson]

Qtd => doble precision
Custo => numeric (9,2)

select Custo*Qtd from tabela

vc já tentou assim?

select CAST((Custo*Qtd) AS NUMERIC(9,2)) AS RESULTADO from tabela

sem mais

Joelson 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005