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, […]