Q
Problem solve Get help with specific problems with your technologies, process and projects.

Converting words to numbers in DB2, and vice versa

I would like to ask, is there a built in function in DB2 that will convert a date into its word equivalent? How about numbers?

I would like to ask, is there a built in function in DB2 that will convert a date into its word equivalent? (e.g. 2003-04-10 and output April 10, 2003) How about numbers? (e.g. 21 - output "twenty one")
There is no built-in function in DB2 to convert dates or numbers into their English equivalent. Of course, you can always write your own user-defined DISTINCT function to do this - but it would probably take a significant amount of programming.


Have a database question of your own? Send it our way and we'll give it to our panel of experts to answer. Check out these other titles for more tips and news on DB2 and DBMS:

 

Dig Deeper on IBM DB2 management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close