RE: Number problem

From: Vinod Gopinath BMMI IS <vinodg_at_BMMI.com.bh>
Date: Thu, 23 Dec 2004 15:56:40 +0300
Message-ID: <C9239A40098E1B47815F48965A7D0BF134B76C@BMMIXCH.BMMIHQ.Root.AD>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 Received on Thu Dec 23 2004 - 06:46:27 CST