Database Software

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 decimal numbers half up in XSL

FofanaNov 6 2018 — edited Nov 7 2018

Hi,

I would like to apply the rounding half up.

This format_number I found in docs tends to do a round half down: format-number(amount,'#,##0.00','dollar')

But I want to round to 2 digits for example:

0.105 becomes -----------> 0.11

0.104 becomes -----------> 0.10

How to achieve that?

This post has been answered by _jum on Nov 7 2018

Jump to Answer

Added on Nov 6 2018

#performance-availability, #xml-db

3 comments

2,797 views