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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 14 Jun 1999 17:11:40 +0100
Message-ID: <929376927.24742.0.nnrp-03.9e984b29@news.demon.co.uk>

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(

---

Vendredi

--

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
>
>
Received on Mon Jun 14 1999 - 11:11:40 CDT