Home » SQL & PL/SQL » SQL & PL/SQL » convert a number to money format with $ (Orace 10G, V10.2.0.1.0, Widows XP)
convert a number to money format with $ [message #351313] Tue, 30 September 2008 05:04 Go to next message
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
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
JRowbottom
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: Thu Dec 08 12:28:14 CST 2016

Total time taken to generate the page: 0.10042 seconds