Format number without converting to char?
Hi,
I would like to control the amount of digits of a numeric field in my query results. The query returns real numbers with varying precision.
Of course, you can use to_char(), but that converts all numbers to strings and the result will be left aligned.
Using the round function is also not sufficient, because it will not display trailing zeros, e.g. round(0.120,3) results in 0.12
Is it possible to format a number in another way?
Thanks!
Rob