Re: numeric to fully-written-numbers pl/sql translator

And if the syntax:

select to_char( to_date(5373484,'J'),'Jsp','nls_date_language=french') from dual

did for the Jsp format what it does for all the other character type formats you would be done.

select to_char( to_date(5373484,'J'),'Day','nls_date_language=french') from dual;

TO_CHAR(

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Thomas Kyte wrote in message <376e20e8.12358951_at_newshost.us.oracle.com>...



>TO_CHAR(TO_DATE(5373484,'J'),'JSP')

>--------------------------------------------------------------------------


>Five Million Three Hundred Seventy-Three Thousand Four Hundred Eighty-Four

>

>