Re: Dates - automatic translations of month

From: Joachim Schneider <jodel_at_gmx.net>
Date: Mon, 17 Feb 2003 11:56:25 +0100
Message-ID: <3E50BFD9.2030407@gmx.net>

see Oracle9i Database Globalization Support Guide Release 2 (9.2) (Part No. A96529-01), i.e. go to <http://otn.oracle.com>

You want:

TO_CHAR(frenchdate, 'DD/MON/YYYY', 'nls_date_language = FRENCH')

Joachim

Jeremy Ovenden wrote:
> Anyone know an easy way of translating months into different languages?
>
> e.g.
>
> 25-may-2003
>
> for a french user I would like to display
>
> 25-mai-2003 (assuming my french is up to scratch!)
>
> This is a web app with all accesses coming thru a single oracle account.
>
> Any ideas?
>
Received on Mon Feb 17 2003 - 04:56:25 CST