Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Feb 15, 2005

Converting Numbers into Words

Ever written a PL/SQL block of code to convert numbers to words? Try this easy line of code to accomplish the same task:

SELECT TO_CHAR(TO_DATE(764,'J'), 'JSP') AS WORD_FORM FROM DUAL;
Here the 'J' option specifies that the conversion is to Julian format.

The result will be:


WORD_FORM
------------------------
SEVEN HUNDRED SIXTY-FOUR
MS Sridhar
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap