Change decimal seperator in Teradata Studio Output

Teradata Studio
Enthusiast

Change decimal seperator in Teradata Studio Output

Is it possible to change the decimal seperator from . to , in Teradata Studio?

 

12.98 -> 12,98 ?

 

Thanks for any suggestions!


Accepted Solutions
Enthusiast

Re: Change decimal seperator in Teradata Studio Output

Hi Sivasai,

 

I meant in the result set viewer sorry.

 

Just solved this by checking 

Display 1000 separator in Numeric Columns

this will also change the decimal seperator to ","!

1 ACCEPTED SOLUTION
3 REPLIES
Enthusiast

Re: Change decimal seperator in Teradata Studio Output

Hi Sebastian,

 

Please check the below code

SELECT oreplace(cast(12.98 as varchar(5)),'.',',') (int)(format 'Z(3),ZZ') output
Enthusiast

Re: Change decimal seperator in Teradata Studio Output

Hi Sivasai,

 

I meant in the result set viewer sorry.

 

Just solved this by checking 

Display 1000 separator in Numeric Columns

this will also change the decimal seperator to ","!

Teradata Employee

Re: Change decimal seperator in Teradata Studio Output

Studio will use the system locale to format the decimal. Make sure the Region and Language is set on your system.