CODEWITHSUNDEEP
oracle-database
Tiago Dias
Tiago Dias

Reputation: 71

Formatting a decimal column into euro currency

I need to format a decimal value into a string with the format ###.###,##.

I've already tried:

SELECT to_char (11230.3423, '999,990.00') FROM DUAL

I'll get 11,230.34 where i want 11.230,34.

If i change the format as:

SELECT to_char (11230.3423, '999.990,00') FROM DUAL

I'll get an error.

Note: I need to format Euro(€) values so decimal separator is ','.

Thanks.

Upvotes: 0

Views: 523

Answers (1)

Radagast81
Radagast81

Reputation: 3016

Use:

SELECT to_char (11230.3423, 'FM999G990D00', 'NLS_NUMERIC_CHARACTERS = '',.''') FROM DUAL

Upvotes: 2

Related Questions