SQL - Rounding off to 2 decimal places

sql rounding
user656523 picture user656523 · Apr 30, 2012 · Viewed 883.6k times · Source

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

u07ch picture u07ch · Apr 30, 2012

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

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

Returns

10.500000   10.50

Related questions

Truncate (not round) decimal places in SQL Server

I'm trying to determine the best way to truncate or drop extra decimal places in SQL without rounding. For example: declare @value decimal(18,2) set @value = 123.456 This will automatically round @value to be 123.46, which is good in most cases. However, for …

Read More
How to round down to nearest integer in MySQL?

How would I round down to the nearest integer in MySQL? Example: 12345.7344 rounds to 12345 mysql's round() function rounds up. I don't know how long the values nor the decimal places will be, could be 10 digits with 4 decimal places, could be 2 …

Read More
Discard millisecond part from timestamp

How can I discard/round the millisecond part, better if the second part is also removed from a timestamp w/o timezone ?

Read More