Re: Number problem

From: Steve Jelfs <steve@xxxxxxxxxxxxxx>
To: steve@xxxxxxxxxxxxxx
Date: Thu, 23 Dec 2004 12:55:40 +0000

Steve Jelfs wrote:
>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
>
>
>  
>

Sorry to answer my own question but how often do you ask a question only 
to have a eureka moment???  i think this does it for anyone who remains 
curious!

floor(:num/10000)*10000+5000*(floor((mod(:num,10000)/5000)+1))

Steve - feeling pleaseD with himself!!

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

References:

Number problem
From: Steve Jelfs

Re: Number problem

Other related posts: