Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> schrieb:
> Hi list,
>
> Here in my country (Brazil) we have the decimal simbol as ' , ' (commas) and
> thousand separator as ' . ' (point)
>
> Here my sql uses: to_char(sum(My_column), '99990D00')
>
> Is there any way to make this happens ?
I think, you can use the 'G' as a group separator for this:
test=*# select to_char(12345.67, '999G990D00'); to_char
------------- 12.345,67
(1 row)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°