OraFAQ Forum: SQL & PL/SQL » convert a number to money format with $

Home » SQL & PL/SQL » SQL & PL/SQL » convert a number to money format with $ (Orace 10G, V10.2.0.1.0, Widows XP)

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

convert a number to money format with $ [message #351313]

Tue, 30 September 2008 05:04

Notorious96
Messages: 7
Registered: September 2008

Junior Member

I have a coloumn in my table that has data of type float which basically stores a number which is the charge of an item. How can we convert it to a 'money format'?

convert 1234 to $1,234

Report message to a moderator

Re: convert a number to money format with $ [message #351316 is a reply to message #351313]

Tue, 30 September 2008 05:10

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

TO_CHAR format masks

Report message to a moderator

Previous Topic:	how to use TO_NUMBER function
Next Topic:	retrieving the min not existing value in a column of a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 07 21:23:38 CDT 2025