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
at
Labels:

No comments:

Post a Comment

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

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...