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
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