Thursday, March 10, 2011

Convert numbers into words

The following query Convert numbers into words

select to_char(to_date(10000,'J'),'JSP') as "No in words" from dual



select to_char(to_date(22500,'J'),'JSP') as "No in words" from dual





select to_char(to_date(11456,'J'),'JSP') as "No in words" from dual




Note: If one gets the following error
"julian date must be between 1 and 5373484"

Try the following to resolve the same, the error is cause the integer returned is greater than 5373484

SELECT   TO_CHAR (TO_TIMESTAMP (LPAD (7200008, 9, '0'), 'FF9'), 'FFSP')
  FROM   DUAL


No comments:

Post a Comment