Re: nls_date_format

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 Received on Tue Jul 14 1998 - 02:27:13 CDT