Re: NLS_DATE_FORMAT and where is it used??

A copy of this was sent to say_at_qld.mim.com.au (Sarah Yaksich) (if that email address didn't require changing) On Tue, 05 Jan 1999 04:17:28 GMT, you wrote:

>I have come across some info regarding Y2K issues and NLS_DATE_FORMAT.
>I know that this can be set at both the server level and also on the
>Client-side, either in the registry or an .ini file.
>
>I was wondering if anyone could point me in the direction of anything
>that would tell me in what circumstances which NLS_DATE_FORMAT is
>used, the server level one or the client-side one.
>
>Thanks,
>Sarah

If the client sets the NLS_* parameters -- they override the server in all cases. In fact, if the client sets the NLS_LANG parameter -- that causes all NLS_* settings on the server to be ignored and the defaults for that NLS_LANG specified on the client on used.

Where that comes into play is typically if the client is windows and the server is unix. The client install on windows set the NLS_LANG parameter in the registry by default. This setting is different from the default you find for unix. Any NLS_* settings you put in the init.ora will *not* be used by those clients.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.