Sql round mehthod vs C# round method when last value is 5

Question

4.00/5 (1 vote)

See more:

, +

C# code rounding result and SQL Sp Rounding result are different when last value is 5

My Code in C#

double meanObject;

double Upper = 1.8415;

meanObject = Math.Round((Convert.ToDouble(Upper)), 3);

==> Result meanObject = 1.842 <==

My Code in SQL SP

Declare @Upper float = 1.8415

select Round(@Upper,3)

==> Result is = 1.841  <==

I want Same Answer in both
Ex.
C# Code =  1.842
SQL SP  =  1.842  (I get the wrong result in SQL SP : 1.841)

What I have tried:

in C# i tried

double meanObject; double Upper = 1.8415; meanObject = Math.Round((Convert.ToDouble(Upper)), 3); Label1.Text = meanObject.ToString(); //Result 1.842

in SQL Sp i Tried

Declare @Upper float = 1.8415 select Round(@Upper,3)

Posted 24-Jan-19 22:03pm

Anuj Mehta

Updated 25-Jan-19 0:02am

Add a Solution

Comments

phil.o 25-Jan-19 4:52am

Why are you trying to convert to a double value something which is already declared as a double value?

Anuj Mehta 25-Jan-19 5:30am

I Added it for Just checking code.

Without converting result is same (no change)
double Upper = 1.8415;
double meanObject = Math.Round((Upper), 3);

Result = 1.841

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Herman<T>.Instance · Answer 1 · 2019-01-24T22:12:00

Solution 1

The reason is that .NET uses bankersrounding.

See here[^] or Bankers’ Rounding – Fabulous Adventures In Coding[^]

Posted 24-Jan-19 22:12pm

Herman<T>.Instance

Comments

Maciej Los 6-Feb-19 6:44am

5ed!

Herman<T>.Instance 6-Feb-19 10:51am

thank you!

Anuj Mehta · Answer 2 · 2019-01-25T00:03:00

Solution 2

Declare @Upper money = 1.8415

select Round(@Upper,3)

Prob Solved using changing datatype to money 
==> SQL Result is = 1.842  <==

Thank You All for responding

Posted 25-Jan-19 0:03am

Anuj Mehta

Comments

Maciej Los 6-Feb-19 6:44am

Great, have a 5!