Grato, abraços.

Em 31/05/07, Osvaldo Kussama <[EMAIL PROTECTED]> escreveu:




jfranco wrote:
>
> Gostaria de saber se tem alguma Função para formatar numeros
> (float,decimal,
> number) para Real (999.999.999,99), via SQL.
>


to_char
http://www.postgresql.org/docs/8.2/interactive/functions-formatting.html

SELECT to_char(seu_numero,'"R$ " 000G000G009D99');

[]s
Osvaldo

--
View this message in context:
http://www.nabble.com/Formata%C3%A7%C3%A3o-de-valores-para-Real-%28R%24%29-tf3848710.html#a10901435
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.


_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral


_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a