DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: language option

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    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

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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
  •  


Click Here to Expand Forum to Full Width