The NLS_DATE_FORMAT on the client always overrides the
setting in the init.ora setting. In addition the
NLS_LANG setting has an implied NLS_DATE_FORMAT of
DD-MON-YY for most settings (see note 93924.1 below
for more details) so on Windows clients, where
NLS_LANG is set in the registry by default, you must
either explicitly set NLS_DATE_FORMAT or remove
NLS_LANG (so it defaults to the server's setting).
A few docs that address this:
Note: 77318.1 "Why is my NLS_DATE_FORMAT parameter
setting not taking effect?"
Note: 60134.1 "NLS Frequently Asked Questions"
Note: 93924.1 "Advisory Warning of change to
NLS_DATE_FORMAT Default values"
HTH,
- Anita
- Vladimir Begun <jester_at_whale.sunbay.crimea.ua>
wrote:
> On Jul 11, 2001 at 12:35:21AM, Rangachari Sundar
> wrote:
> > Hi,
> >
> > I have a requirement. Everytime when i make a
> session to the database i want the
> > Date Format to beas follows
> >
> > 'yyyy-mm-dd hh:mi:ss'
> >
> > The existing default format is 'dd-mon-yyyy' and
> so I tried the following steps.
> >
> > ALTER SESSION set NLS_DATE_FORMAT='yyyy-mm-dd
> hh:mi:ss' and put that in the
> > login.sql it worked fine for my every client
> session.
> >
> > How can I set it globally so that everytime when I
> make a session to database
> > from any client It should be 'yyyy-mm-dd
> hh:mi:ss'.
>
> Set NLS_DATE_FORMAT in init.ora
>
> Would be cool to use dbms_session.set_nls in your
> logon trigger
> but it does not work correctly. See bug 1574885, if
> it's published
> already. (it was not). Search over metalink for
> examples.
>
> --
> Vladimir Begun | There's a lesson
> here. Generalizations are
> http://vbegun.net/ | generally useless
> unless used.
> http://vbegun.net/wap/ | -- Larry Wall
> in
> me_at_vbegun.net |
> <199911192159.NAA23536_at_kiev.wall.org>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Vladimir Begun
> INET: jester_at_whale.sunbay.crimea.ua
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jul 11 2001 - 08:29:28 CDT
