Friday, April 25, 2008

Converting a Number into Words

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.

No comments:

Post a Comment