refering to my math professor thats wrong, at least in germany.
select round(2.5); should return 3

Well, I thought mathematics theory says that you should round to the nearest even number for a 0.5 value, so as to avoid biasing your data...?


I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for round(2.5)

What does 3.5 do?


And -2.5 and -3.5?

Chri



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to