Format the double precision value in Postgresql

Question

I want to get the value from postgresql with formating. The formatting is user option like they want comma separator or not and with decimal place is 2,3 or 4 like.

So now i wrote query like this.

 Select to_char(rate,'FM999.00') as BasicSaleRate from table1

Its return ans 220.00. How to write the query with comma separator value like this '#,0.00'. That means the value more than thousands return with comma separator or not.

Am using postgresql 9.3

Thank you

user3020494 · Accepted Answer · 2013-11-23 06:54:02Z

2

See this reference http://www.postgresql.org/docs/9.3/static/functions-formatting.html to_char(rate,'FM999,999.00')

answered Nov 23, 2013 at 6:54

user3020494

7326 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Format the double precision value in Postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related