Skip to Content
avatar image
Former Member

Trimming Zeros after the decimal

Hi All,

I have a requirement to trim zeros after the decimal and should round the value as well

can anyone help me in that

Thanks in Advance

for eg, i have a column like

Date_units

123.00

234.13

4567.85

9876.13

The output needs to be

Date_units

123

234.1

4567.9

9876.1

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 06, 2017 at 09:52 AM

    replace_substr(to_char(round(Date_units, 1),'99999990D.0'), '.0', '')

    Add comment
    10|10000 characters needed characters exceeded