Re: nls_date_format

Hi,

You must set this parameter on each client workstation independently. It is in registry for Win95/98/NT.

Andrew Protasov

In article <36C84B82.E7B61D4C_at_cceb.upenn.edu>,   Xueyou Hu <xhu_at_cceb.upenn.edu> wrote:
> my problem:
>
> I create a new database, the default nls_date_format is 'DD-MON-YY', but our
> project span from 1890-1999, I need to change the nls_date_fromat to
> 'MON-DD-YYYY', I try "alter session set nls_date_format = 'MON-DD-YYYY'", it
> is ok, the format work in this session, then I go to initial parameter file
> to change the the nls_date_fromat to 'MON-DD-YYYY', shutdown and startup the
> database, but it doesn't work. I don't know why, anybody can tell me how to
> make that work.
>
> Thanks in advance.
>
> Stanley Hu
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 16 1999 - 00:00:00 CST