user656523 user656523 - 2 years ago 100
SQL Question

SQL - Rounding off to 2 decimal places

I need to convert minutes to hours, rounded off to 2 decimal places.I also need to display only up to 2 numbers after the decimal point. So if I have minutes as 650.Then hours should be 10.83

Here's what I have so far:

Select round(Minutes/60.0,2) from ....

But in this case, if my minutes is, say,630 - hours is 10.5000000. But I want it as 10.50 only(after rounding). How do I achieve this?

Answer Source

Could you not cast your result as numeric(x,2)? Where x <= 38

    cast(round(630/60.0,2) as numeric(36,2))


10.500000   10.50
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download