I have the following query:
SELECT SUM(ValorBruto)
FROM faturas
WHERE DataCaptura between'2018-10-01' and '2018-10-30'
The result is displayed to 4 decimal places. I would spend only viewing 2. How do I?
I have the following query:
SELECT SUM(ValorBruto)
FROM faturas
WHERE DataCaptura between'2018-10-01' and '2018-10-30'
The result is displayed to 4 decimal places. I would spend only viewing 2. How do I?
Try something like this
SELECT round(CAST(float8 SUM(ValorBruto) as valorBruto),2)
FROM faturas
WHERE DataCaptura between'2018-10-01' and '2018-10-30'