Skip to Main Content

Oracle Database Discussions

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!

Convert number to string with specific format

user8021820Feb 26 2014 — edited Feb 26 2014

Hi all,

Starting from a number (10,2) I need to conver in varchar preserve leading zero e "." as decimal separator.

Here some example:

number          string (result)

------------------------------------------------

0,22                0.22

10,2                10.2

1234,33           1234.33

How is the best solution?

Ugo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2014
Added on Feb 26 2014
1 comment
219 views