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 are, say,630 - hours is 10.5000000. But I want it as 10.50 only(after rounding). How do I achieve this?