By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,502 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

currency format

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Thanks Serge

Sep 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.