CODEWITHSUNDEEP
sqloracle-databaseto-char
Manish
Manish

Reputation: 1972

Appending '0' after decimal in Oracle

I want to append trailing '0' to number while performing Select query:

what I want is to select

344.89 as 344.890

123213.45 as 123213.450

1.2 as 1.200

I tried using to_char(col_name,'000000.000') but that resulted in

344.89 => 000344.890

123213.45 => 123213.450

1.2 => 000001.200

there were unwanted '0' appended to the result.

Upvotes: 4

Views: 3492

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269513

You are close with the to_char format. Try this:

to_char(col_name,'999999.000')

The 9s represent optional place holders. The 0s represent putting in leading zeros.

Upvotes: 9

Related Questions