Re: Problem with NLS_LANG: Clients versus database

maverick_at_videotron.ca (Pierre) wrote:

> But is there a way to change the NLS_LANG at another level ??

NLS_LANG=american_america.we8dec

In SQL you can do:

select to_char(sysdate,'day DD month yyyy','NLS_DATE_LANGUAGE=dutch') from dual;

to get Dutch day and month names.

HTH

--
Ludo Joris
RUCA - University of Antwerp, Belgium
lujo_at_ruca.ua.ac.be