"Saurabh Mittal" <lattim(at)hotmail(dot)com> writes:
> select ROUND(0.5) ; returns 0
> select ROUND(1.5) ; returns 2;
> select ROUND(2.5) ; returns 2;
> select ROUND(3.5) ; returns 4;....so on .=20
> I'm sure you would have figured out what's happening !!! Why ??
Because the IEEE float math standard says so. Round-to-nearest-even
is considered good practice.
> How do I get to approximate any number x.5 as x+1 ??
Try FLOOR(x + 0.5) if you really want the other behavior.
regards, tom lane