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 ....
Could you not cast your result as
x <= 38
select round(630/60.0,2), cast(round(630/60.0,2) as numeric(36,2))