Re: nls_date_format

I though you should change the NLS_DATE_FORMAT registry under Windows environment, not NLS_DATE.

Winnie Liu

In article <6of18h$7nc$1_at_nnrp1.dejanews.com>,   kstingel_at_my-dejanews.com wrote:
> but if you remove the nls_lang entry from your registry and replace it with a
> new entry for nls_date="DD-MON-YYYY" then use sqlplus & select sysdate from
> dual; then the date year format is still default YY.
> From unix if I connect to the same db & run the same query I get year format
> YYYY as in the init.ora I only have an entry for nls_date not nls_lang.
> Any ideas why NT behaves different and how to change the default date format
> for a client connection?
>
> regards
> Kelvin
>
> In article <35950d74.1613830_at_192.86.155.100>,
> tkyte_at_us.oracle.com wrote:
> >
> > A copy of this was sent to tmurphy_at_pinnsoft.com
> > (if that email address didn't require changing)
> > On Fri, 26 Jun 1998 18:03:51 GMT, you wrote:
> >
> > >When I set my unix init.ora to:
> > > nls_date_format = "DD MON RRRR"
> > >then restart the instance, the svrmgr "show parameters nls"
> > >shows the new format.
> > >also, when I start SQLplus and do a "select * from v$nls_parameters",
> > >my new format is active in my session and all is well.
> > >
> > >When I do the same on NT, the "show parameters nls" shows
> > >the new format, but the sessions end up with the standard "DD-MON-YY"
> > >format. If I explictly "alter session set nls_date_format = 'DD MON
RRRR'",
> > >then that session is OK, but the instance wide default is
> > >still "DD-MON-YY".
> > >
> > >Any clues on why Oracle acts differently on NT than Unix?
> >
> > Its not just NT. It is any client that has specified some of the NLS_*
> > parameters in the environment (or registry on Windows).
> >
> > The default client install on NT sets the NLS_LANG variable in the registry.
> If
> > you specify one of the NLS_* params, it assumes you are going to set them
all
> > (or let them default). Since NLS_LANG is set in the registry on the client,
> > NLS_DATE is defaulting the default format mask for that NLS_LANG.
> >
> > You will see this in a UNIX environment if you set the NLS_LANG environment
> > variable as well.
> >
> > >
> > >Thanks!
> > >
> > >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > >http://www.dejanews.com/ Now offering spam-free web-based newsreading
> >
> > Thomas Kyte
> > tkyte_at_us.oracle.com
> > Oracle Government
> > Herndon VA
> >
> > 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.
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 14 1998 - 13:01:24 CDT