How to show the zero in 0.24

Question

Hi so i have been using to_char to round off my decimal to 2 digit. However, when it encounter value like 0.24 it only display .24 and ignore the 0. How should i make it to display 0.24?

to_char(0.24,'9,999,999.99')unit_price

you want `'9,999,990.99'`, a `9` is an optional, a `0` represents a definietly shown number, even if non would need to be shown as the `.24` in your case. — SomeJavaGuy, Jan 25 '17 at 06:41
Or even `'999G990D99'` to avoid hardcoding ',' and '.' as the thousands and decimal separator charactors. `G` and `D` reflect the current setting for `nls_numeric_characters`. — William Robertson, Jan 25 '17 at 10:03

Avrajit Roy · Answer 1 · 2017-01-25T10:33:50.373

1

Try this.

SELECT TO_CHAR(0.24,'0.00') FROM DUAL

edited Jan 25 '17 at 10:33

answered Jan 25 '17 at 06:44

Avrajit Roy

3,233
1
13
25

You're applying to_char to a string – Aleksej Jan 25 '17 at 08:59
My bad. It was a type. :) – Avrajit Roy Jan 25 '17 at 10:33

score -2 · Answer 2 · answered Jan 25 '17 at 06:43

-2

Try lpad(to_char(0.24,'9,999,999.99')unit_price, 4)

answered Jan 25 '17 at 06:43

kwalski

580
7
15

to fiddle with strings is not the right way to format a number – miracle173 Jan 25 '17 at 07:03

How to show the zero in 0.24

2 Answers2

Linked

Related