I have a
ESTOQUE table containing a field called
QTDE , this field has 3 decimal places.
What would be the command to return directly from SQL formatted with 3 places? Because the integer values are returning without the places.
I use: Firebird 2.0 / Field: Decimal(15,3)
Try like this:
SELECT cast(seu_campo AS NUMERIC(15,3)) FROM sua_tabela
I believe your intention is to show this on the screen so try this:
select cast(seu_campo as varchar(10)) from sua_tabela