Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 rounding

Author  Topic 

Tim
Starting Member

392 Posts

Posted - 2001-08-21 : 01:46:05
0.5 rounded to zero decimal places is 1.

So what is -0.5 rounded to zero decimal places?

Should the difference of the rounded values be the same as the difference of the non rounded values?

Should the rounded values both move away from zero?

SQL server's round() function returns -1, but I have a client who insists it should be zero.

Any math genius who knows the correct answer?







-----------------------------------------------
ask again later...
   

- Advertisement -