RE: Number problem

SQL> select round(96136462/5000)*5000 from dual;

ROUND(96136462/5000)*5000
-------------------------
                 96135000

SQL> select round(96130045/5000)*5000 from dual;

ROUND(96130045/5000)*5000
-------------------------
                 96130000

Is this OK...


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Steve Jelfs
Sent: Thursday, December 23, 2004 3:38 PM
To: Oracle-L Freelists
Subject: Number problem


Within Oracle, how can I round up an 8 figure number to the nearest 5000

such that 96136462 becomes 9614000 and 96130045 becomes 96135000?
Maths was never my strong point!!!   ;-)

Steve



--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: