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 ??