How to handle "currency" in Vertica

[adrian.oprea]

Thank you "SKWA" and "SCUTTER" for the effort in helping me !!

[id10t]

Hi!

>> shouldn't this be already in Vertica by default ?
May be, but take in account that main goal of Vertica is analytics and NOT! data representation. Data should be represented by BI tools and them must have such ability.

[sarah]

Could you use the translate function when you want to display the data?

Code: Select all

dbadmin=> SELECT translate(to_char(123456.77,'R$ 999G999G999D99'), ',.', '.,');
     translate
--------------------
 R$      123.456,77
(1 row)

[adrian.oprea]

Wow , that was it !!

Thx
IOY

[adrian.oprea]

Even a better solution is :
Set the locale: (if more than one node, set this in the .profile, .bashrc of the dbadmin user, or just set it as the system wide locale)

Code: Select all

export LC_ALL=pt_BR.UTF-8
Start Vertica.
On vsql:
dbadmin=> SELECT TO_CHAR(12343148.56, 'L999G999G999G999D99');
          TO_CHAR          
---------------------------
 R$      12.343.148,56
(1 row)

Thank you Carlos,
PS more detailes on this on page "Set the Host Locale (Language)" in the online documentation at vertica site !!

How could i miss this !! OMG

[scutter]

Glad you resolved this. I thought you were trying to convert between mulitple currencies, not just display in a single local currency.

[adrian.oprea]

Glad you resolved this. I thought you were trying to convert between mulitple currencies, not just display in a single local currency.

I think i need to improve the way i put things in English .
Thx ALL