Hi All,
We need to add thousand separator in amount field. We used to_char(column_name, 'FM999,999,999,99'). This works fine when we have amount >=1.
It gives issue for less than one. For example, if value is 0.01, it results in .01 and if value is 0, then 0. Can someone help me? we need in below way
1234567.89 = 1,234,567.89
0.01 = 0.01
0 = 0