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 ??
If the output looks like ##,###,###, the number is too big for the format.
Use a longer format string like
FM99,999,999,999