How to Accurately Round Minutes to Hours with Decimal Precision in SQL?

Round Off Minutes to Hours in SQL with Decimal Precision

One common task in data analysis is converting minutes to hours, often requiring rounding off to a specific decimal place. To round off to two decimal places in SQL, you might initially try:

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

However, this approach may not provide the desired precision for values like 630 minutes, which will result in an hour value of 10.5000000 instead of the intended 10.50.

To achieve the correct precision, you can utilize SQL's casting capability. By casting the rounded value to a numeric data type with a specific precision and scale, you can truncate the unnecessary decimal digits:

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

In this example, we cast the rounded value to numeric(36,2), where 36 denotes the total number of digits and 2 represents the number of decimal places.

Executing this query will yield the expected results:

10.500000    10.50

By employing the casting technique, you can effectively round off values to two decimal places while ensuring the desired level of precision in your SQL operations.

The above is the detailed content of How to Accurately Round Minutes to Hours with Decimal Precision in SQL?. For more information, please follow other related articles on the PHP Chinese website!