470,591 Members | 1,598 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

currency format

Dear All
db2 8.2.4,windows
Is there any way of formatting numerical fields in currency format.I want
to display the salary or employees like $200,000.Is there any inbuilt
function in db2 for this(In oracle, I guess this is done using TO_CHAR
function.Dont know much in Oracle). I know there can be a separate UDF for
this but I just want to confirm if there is any in built function already
available.

Thanks in advance.
Praveen

Sep 18 '06 #1
2 6717
Praveen_db2 wrote:
Dear All
db2 8.2.4,windows
Is there any way of formatting numerical fields in currency format.I want
to display the salary or employees like $200,000.Is there any inbuilt
function in db2 for this(In oracle, I guess this is done using TO_CHAR
function.Dont know much in Oracle). I know there can be a separate UDF for
this but I just want to confirm if there is any in built function already
available.
There is no builtin-function. An SQL function doing this is a trivial
exercise.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 18 '06 #2
Thanks Serge

Sep 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Bill Stanard | last post: by
3 posts views Thread by John L | last post: by
2 posts views Thread by Willing 2 Learn | last post: by
2 posts views Thread by Dalan | last post: by
3 posts views Thread by news.shaw.net | last post: by
2 posts views Thread by Bob Dydd | last post: by
4 posts views Thread by Gerry Abbott | last post: by
2 posts views Thread by crferguson | last post: by
2 posts views Thread by Ian | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.