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.
You are close with the to_char
format. Try this:
to_char(col_name,'999999.000')
The 9
s represent optional place holders. The 0
s represent putting in leading zeros.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With