Postgresql rounding numeric value

Question

I'm trying to get an output of 3 decimal places out of the below query.

the output i'm getting is 2.2600

if I changed the parameter 4 to be 3 in round function below, the output will be 2.300

which is incorrect, it should be 2.26

Select date(time), 

    round((count(case WHEN status='404 NOT FOUND' THEN 1 END))
    /
    (count(*))::numeric,4) * 100 as error_percentage

from log GROUP BY date(time)
ORDER BY error_percentage DESC

That shows the number rounded as whole. I still want to show the first 3 decimal places — Se7sNator
– Se7sNator, Commented Mar 31, 2019 at 9:00

Lukasz Szozda · Accepted Answer · 2019-03-31 09:17:50Z

2

You could use:

SELECT date(time), 
    ROUND(100.0 * (count(*) FILTER(WHERE status='404 NOT FOUND'))/(count(*)),3) 
    as error_percentage
FROM log 
GROUP BY date(time)
ORDER BY error_percentage DESC

answered Mar 31, 2019 at 9:17

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql rounding numeric value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related