Try this
SELECT TO_CHAR(TO_DATE(5373484,'J'),'JSP') FROM DUAL;
The number can not be bigger than 5373484 because of maximum possible value of Julian date.
Friday, April 25, 2008
Converting a Number into Words
Labels:
Sqlplus Tricks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment