What i get is something like:
select round(1.5),round(1.49999),round(1.5000001) from dual;
ROUND(1.5) ROUND(1.49999) ROUND(1.5000001)
---------- -------------- ----------------
2 1 2
What I need is something like:
select round(1.5),round(1.49999),round(1.5000001) from dual;
ROUND(1.5) ROUND(1.49999) ROUND(1.5000001)
---------- -------------- ----------------
1 1 2
What can i do?
i dont like the idea of
change sentences
round(number) with round(number - 0.0000000001)
each time i need to round into my PL/SQL procedure.
Thanks in advance
Sorry for my english and whish you a nice day
from Canary Islands
tarko
select round(1.5),round(1.49999),round(1.5000001) from dual;
ROUND(1.5) ROUND(1.49999) ROUND(1.5000001)
---------- -------------- ----------------
2 1 2
What I need is something like:
select round(1.5),round(1.49999),round(1.5000001) from dual;
ROUND(1.5) ROUND(1.49999) ROUND(1.5000001)
---------- -------------- ----------------
1 1 2
What can i do?
i dont like the idea of
change sentences
round(number) with round(number - 0.0000000001)
each time i need to round into my PL/SQL procedure.
Thanks in advance
Sorry for my english and whish you a nice day
from Canary Islands
tarko