CODEWITHSUNDEEP
postgresql
ungalnanban
ungalnanban

Reputation: 10327

PART 2 - Formate the double precisiont's as 0.00 in postgreSQL

SELECT trim(to_char(123,'9999999999D99'));

123.00 (1 row)

SELECT trim(to_char(00,'9999999999D99'));

.00 (1 row)

I wrote the above query it giving the result as .00 if the amount is 0 (Zeor)? I need the output formate as 0.00. how to do this.

PART -1 Format double precision in PostgreSQL

Upvotes: 0

Views: 1152

Answers (2)

Frank Heikens
Frank Heikens

Reputation: 127456

Use a 0 instead of 9 of:

SELECT trim(to_char(00,'999999990D99'));

Upvotes: 1

David M
David M

Reputation: 72930

You need to use the following:

SELECT trim(to_char(00,'9999999990D99'));

The 0 sets a leading zero.

Upvotes: 1

Related Questions