Why is 199.96 - 0 = 200 in SQL? Languages

Why is 199.96 – 0 = 200 in SQL?

I have some clients getting weird bills. I was able to isolate the core problem:Has anyone a clue, what the heck is happening here? I mean, it has certainly something to do with the decimal datatype, but I can't really wrap my head around it...
Read More
Why 199.96 - 0 = 200 in SQL? Languages

Why 199.96 – 0 = 200 in SQL?

I have some clients getting weird bills. I was able to isolate the core problem:Has anyone a clue, what the heck is happening here? I mean, it has certainly something to do with the decimal datatype but I can't really wrap my head around it...
Read More