CODEWITHSUNDEEP
sqlpostgresqlconcat-ws
frontendciyim
frontendciyim

Reputation: 9

Converting currency to format in postgresql

I want to combine two numbers (monthly net/monthly gross) and edit their formats. for example; 784.453,14

The code I wrote is as follows;

concat_ws('/'::text, 
          btrim(to_char(ks.aylik_kira, '9G999G999G999D00'::text)),   
          btrim(to_char(ks.aylik_kira_brut, '9G999G999G999D00'::text))
) AS aylik_net_brut,

but I'm getting an error and it's not working. How can I do that?

the result should be like this: 147.422,12/148.587,5

Upvotes: 0

Views: 47

Answers (0)

Related Questions