Home » SQL & PL/SQL » SQL & PL/SQL » convert a number to money format with $ (Orace 10G, V10., Widows XP)
convert a number to money format with $ [message #351313] Tue, 30 September 2008 05:04 Go to next message
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
Re: convert a number to money format with $ [message #351316 is a reply to message #351313] Tue, 30 September 2008 05:10 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
TO_CHAR format masks
Previous Topic: how to use TO_NUMBER function
Next Topic: retrieving the min not existing value in a column of a table
Goto Forum:

Current Time: Mon Jun 26 12:11:14 CDT 2017

Total time taken to generate the page: 0.09551 seconds