Rounding SUM (Float ) to one Decimal in PostGreSQL

Viewed 2638

I want to round off the sum to one decimal i'm trying this below

round(sum(cast(expend as float)/1000),1) AS "ROUNDING TO ONE DECI"

It says as function round(double precision, integer) does not exist

Please can anyone say about this

0 Answers
Related