Re: oracle date

"Frank Leenders" <ftleenders_at_hotmail.com> wrote:

>Thanks for your extensive reaction Kyle. But setting nls_date_format in the
>registry (NT4.0) has no consequence, alter session works fine. Does the
>registry setting influence sql+? I thought it didn't. So it seams I can set
>the dateformat in init.ora without problems.
>(we indeed use WNT4.0 on the clients and AIX on the sever)
>Regards
>Frank
>
>
>

I'm not sure about your setup, but setting NLS_DATE_FORMAT in the registry will have an impact....If there are ANY nls_ parameters set in the registry then ALL nls_ parameters will either use the registry settings ( if any ) or the Oracle Default settings for your language ( usually DD-MON-YY ) - in other words ALL init<sid> nls_ parameters are ignored when a registry value exists for ANY nls_

This usually happens when any Oracle client product is installed .. it will set the language nls_ parameter at the very least....then the overide is triggered...

If you set NLS_DATE_FORMAT equal to the init<sid..ora file, all will be well...

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Aug 09 1999 - 13:08:49 CDT