0
I need to convert a value $1,500,35
(american standard), for R$1.500,35
(Brazilian standard), but the language used in the bank is American and the functions I know only convert the value to the current language of the bank. How can I do that?
Example of query I’m using:
select (invoice_data->'valor_cobrado')::money as "Valor acumulado" from tb_invoice where invoice_number = 4653801
Query result: $14,825.00
I need to return this: R $ 14.825,00
It may be just because it’s not clear, but it doesn’t seem to make sense. Show better what you want.
– Maniero
American standard, and database:
000,000,000.00
. in the language, follows the same pattern, will only change in the display, according to what you choose... you should at least tell what language you are using and show the code you want to implement– Rovann Linhalis
particularly, I use Numeric, not money... I leave the formatting to the application side
– Rovann Linhalis