-
I write this query to get a number in letters:
select to_char(to_date(1985,'J'),'JSP') from dual;
and I get:
TO_CHAR(TO_DATE(1985,'J'),'JSP')
-------------------------------------
ONE THOUSAND NINE HUNDRED EIGHTY-FIVE
Can I get the result in a different language than english?
Thanks
-
Restriction for format suffixes: SP, THSP, TH, THSP :
When you add one of these suffixes to a datetime format element, the return value is always in English.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|