Query help for rounding off

Question

Dear Experts

Please help in converting below amount field into two decimals.

For the below query i tried it is getting rounding off

SELECT CAST (105798/ 100 AS DECIMAL (25,2))

Expected result

1057.98

But I am getting result as 1057.00

Please help experts.

Answer 1

But I am getting result as 1057.00

You calculate with integer values and so you get integer as result = no decimals. Convert the value to numeric value, e.g. simply multiply with 1.0

SELECT CAST (1.0 * 105798/ 100 AS DECIMAL (25,2))

Answer 2

Thank you so much and it helped me much and worked awesome.