OraFAQ Forum: SQL & PL/SQL » HAving trying trying to convert a number to a currency format.

Home » SQL & PL/SQL » SQL & PL/SQL » HAving trying trying to convert a number to a currency format.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HAving trying trying to convert a number to a currency format. [message #19697]

Thu, 04 April 2002 04:28

Sabrina
Messages: 76
Registered: February 2002

Member

I am trying to change a number column to a currency format. All i want is the number to show up in a currency format e.g. $99,99,999.99..
Please tell me what am i doing wrong.
Thanks.

1 select TO_CHAR(sum(tbl_claimshistory.totalamount/100),'L99G999D99MI')
2* from tbl_claimshistory
SQL> /

TO_CHAR(SUM(TBL_CLAI
--------------------
####################

SQL>

Report message to a moderator

Re: HAving trying trying to convert a number to a currency format. [message #19698 is a reply to message #19697]

Thu, 04 April 2002 04:33

John R
Messages: 156
Registered: March 2000

Senior Member

Having the output field filled with # means that the number is larger than the format mask. Use a larger format mask and try again.

Report message to a moderator

Previous Topic:	SQL underdstands variable in a wrong way
Next Topic:	about explain plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 08:48:05 CDT 2024