APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to round figure to the nearest penny?

809712Nov 17 2010 — edited Nov 17 2010

I want to calculate the average holiday cost and then round that figure to the nearest penny(or two decimal places). Here is my code for finding the average.

select	 avg(IT220_HOLIDAYDETAILS.HOLCOST) as "HOLCOST" 
 from	 "IT220_HOLIDAYDETAILS" "IT220_HOLIDAYDETAILS"

This works fine but the result is 1201.3333333333333

I tried to use the round function but all it did was take all the decimal places off alltogether. I want to round it to two decimal places, is there a way to do this?

Thanks in advance!

Edited by: Jay on 17-Nov-2010 04:06

This post has been answered by munky on Nov 17 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2010

Added on Nov 17 2010

#apex-discussions

11 comments

1,791 views