ceil or round in oracle

select (10.5*15.01) from dual


157.605

I tried using ceil and also round

I get the value 158.

I need help in decimals. 605 has to be 61 -- 157.61
LVL 6
anumosesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sdstuberConnect With a Mentor Commented:
if you want formatting, convert it to a string

select to_char((ceil(100*70*15.01)/100),'fm9999.00') from dual
   
   select to_char(round(70*15.01,2),'fm9999.00') from dual
0
 
sdstuberCommented:
select round(10.5*15.01,2) from dual


select ceil(100*10.5*15.01)/100 from dual
0
 
PaulCommented:
select
  round(x,0)
, round(x,3)
, ceil(x)
, floor(x)
from (
      select (10.5*15.01) as x from dual
     )

Open in new window

ROUND(X,0)      ROUND(X,3)      CEIL(X)      FLOOR(X)
158                 157.605         158         157

not sure what you are asking for
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
anumosesAuthor Commented:
select (ceil(100*70*15.01)/100) from dual
   
   select round(70*15.01,2) from dual

1050.7

Is there a ways to have 1050.70?
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
... or just do the formatting "later" within your frontend...

But the point is: what exactly are you asking for / what do you want to do ?!
0
 
anumosesAuthor Commented:
I am asking for formatting the numbers that I get as results. rounding the decimals to 2 decimals.
0
 
sdstuberCommented:
formatted rounded to 2 decimals....


 select to_char(round(70*15.01,2),'fm9999.00') from dual
0
 
PaulCommented:
http://www.techonthenet.com/oracle/functions/
http://www.techonthenet.com/oracle/functions/ceil.php
http://www.techonthenet.com/oracle/functions/floor.php
http://www.techonthenet.com/oracle/functions/round_nbr.php

with round() YOU specify the number of decimals points as the second parameter in that function

for "display" you use to_char, THEN there you may also specify the number of decimal points to show for presentation by the "format mask" (which is the second parameter to that function).
http://www.techonthenet.com/oracle/functions/to_char.php

I'd suggest you get familiar with these functions
0
 
anumosesAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.