David, you put too many words but did not answered my questios.

One of them:

Which day the midnight event belongs? Previous or next?

Forget about bankers. Answer for yourself.

Here comes the diffeence between banking and real world.

There is no such thing as precise numbers in real world.

Length of precise number interval on any axis = dx -> 0.

So,...

So, for 2000 numbers between 0(including) and 0.2(excluding) after rounding you've got 1100 numbers equal to FLOOR and 900 equal to CEILING.

Fair?

How can you prove which result is right:

.990000

or

0.98999999999999999

?

Don't tell me about something you believe. Prove it.

The only scientific way to prove it is to try to get original value back.

If...

What are you trying to prove?

0.33 is not 1/3.

And 3*.33 will return some result we have nothing to compare with.

Real test for precision must contain return to the point.

If you...

And missing 200 go in favor of ...?

Be careful and never disappoint the one who sends strings to you.

Because being in bad mood he could send something like 'DROP DATABASE YourDBName'.

And it would be executed without errors....

I answered to Jeff already.

David, (another one this time )

That's what I was trying to do from the beginning:

because I'm not familiar with any programming language I was...

David, makea table, populate 1st column witn money numbers from 0.000 to 0.1999 step 0.0001.

This will cover both cases of Banker Rounding.

Populate 2nd column with bnRound result from Col1.

Count number...

"Too much proud" problem?

I never told you're stupid.

You took that privilege.

I stated that whole idea of Bankers Rounding is stupid. And I can prove it.

You defined precision by yourself. Did you forget...

I don't need that code.

We've got here GST rate = 12.5%. It's right from your exaple: 1./8

Now just show me how your Bankers Rounding could help me to get right...

Lynn, I will admit anything you can prove.

Can you?

Lynn, I'm not always right, but here I'm absolutely right.

Try calculate 1./8 + 1./8 using your stupid rounding and tell me does it bring you right result.

Because my way brings...