Categories
Database Development

query output shows ##,###,### instead of right output

I am working on one project in which, query output gives ##,###,### instead of right values.

according to requirement we calculate the time period and display it in separate table.

this is query I am using as calculation

select (to_char((coalesce(11808000,0) - (coalesce(3562.66,0) - (coalesce(1800,0) + (coalesce(1800,0))))),'FM99,999,999'))::character varying as mytest

so if I run this one, it will give output properly, but the seperate table what we use to display output is giving wrong values. can any one help me with this ??

Leave a Reply

Your email address will not be published. Required fields are marked *