PostgreSQL, Format Float

Question

I try to format numeric field

select to_char(12315.83453, 'FM999999999999D9999')

in this case all its OK. Result is 12315.8345

But if value is between 0 and 1

select to_char(0.83453, 'FM999999999999D9999')

result is .8345 without 0 (zero) but I need 0.8345.

What kind of format should be indicate to to_char function to obtain result what I need?

Dan LaRocque · Accepted Answer · 2010-07-13 22:00:52Z

5

SELECT to_char(0.83453, 'FM999999999990D9999');

I just changed the 9 before format D to 0.

answered Jul 13, 2010 at 21:55

Dan LaRocque

5,1932 gold badges24 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1