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