December 7, 2010

Number into word

This is easily done with the following command:


select to_char(to_date('56789','J'),'JSP') from dual
/
TO_CHAR(TO_DATE('56789','J'),'JSP')
--------------------------------------------
FIFTY-SIX THOUSAND SEVEN HUNDRED EIGHTY-NINE

J:- Julian date of 5373484

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load

# Fix of the Day #25: Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load Part of my Oracl...