number separator

VC

 

I want to format the numbers in financial format like in thousands in vsql 

Adrian_Oprea_1

I guess this is what you are looking for:

select to_char(1096,'L9G999G999G999G999D99')

-where L is the currency sign and G is the group separetor and D is the decimal.

VC

Superb!!..

 

Many Thanks Adrian_Oprea_1

Adrian_Oprea_1

 Here is the official documentation on this use case.

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Formatting/TemplatePatternsForNumericFormatting.htm

 

This will give you more details 

VC

Thanks for this, but do you have document or url for create Pattern like 'L9G999G999G999G999D99' 

 

Thanks once again!. Adrian_Oprea_1

Adrian_Oprea_1

 just gave it to you